I Have a package stored in SQL Server which works properly with logging when I run it directly by right-clicking it in SQL Server, with logging. Logging is set to 'SSIS log provider for Text File'. When I run it from an SQL Server Agent Job, it works fine, without errors but the logging isn't done. The job runs with the my user, the s...
The SQL Agent job is returning DTSER_COMPLETION (2) after running an SSIS package. The task of SSIS is completing correctly but is showing many of the following errors: ......Removing this unused output column can increase Data Flow task performance I am not sure whether this can be solved by modifying something in SSIS or the SQL Age...
SSIS package loops through input files. For each file, flatfile parse adds records to a DB table, then file is renames/moved for archiving. After all files, package calls a sproc to delete all year-old records. Package runs from visual studio OK. Put in SSIS package store, run from there, no problem. Create an SQL Agent job to run p...
Hi guys, Can anyone know why all the buttons are disabled ? I am trying to create a Job on SQL Server 2008 R2 Express. Thanks. ...
I need to create an application for monitoring SQL Server 2000 Agent Job status and info when Job occur same as show on Windows application event log. Now I connect to the database already via a connection string, but I don't know how to get the status and info from Job. I need to show status and info on Textbox. What do you suggestio...
Can I (How do I) configure Sql Server 2008 to notify an operator if any step in the Job fails? I have a Sql Server job with several steps to update data from multiple different sources, followed by one final step which performs several calculations on the data. All of the "data refresh" steps are set to "Go to next step on failure". G...
Hello there, I came across these two services separately running in Services.msc - SQL Server (SQLEXPRESS) - started+Automatic SQL Server Agent (SQLEXPRESS) - Disabled Can you please guide why do we need SQL Server Agent (SQLEXPRESS)? Thank you! ...
I have some jobs for example : job1, executing every 2 minutes job2, executing every 10 minutes job3, executing every 15 minutes now there is a problem. jobs may occur simultaneously and cpu usage go to 100%; is there a solution? remind that I need jobs to run approximately in their appropriate period. thanks. ...
I have few SQL Server Agent Jobs running in my project. The jobs run perfectly as scheduled, no issues. But now I need to be able to start these jobs from the front end (Like on a click of button or so). How can I do it ? Do these jobs behave just like a functions ? ...