I was trying to script out all the SQL Server Agent jobs for category ‘Data Warehouse’ into a single file I was able to do it using PowerShell, where every single job creates a single file. But I need one file for all the SQL Server Agent jobs under category ID = 100 (or Category : = ‘Data Warehouse’) Code
Tag: sql-agent-job
The job failed. The job was invoked by user. The last step to run was step1
I have created SSIS package which is running successfully and dumping the data to the required place. But the same package results in the error when i run it through job. I googled n got these links but failed to get the way out- http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/9034bdc4-24fd-4d80-ad8d-cc780943397a/ http://www.progtown.com/topic390755-error-at-start-job-the-job-was-invoked-by-user-sa.html Please suggest . Answer The screen captures are great but the detail is going