March 29, 2009 at 6:36 pm
I tried to schedule SSIS packages which are failing for reasons I do not understand.
After I deploy the SSIS packages to the Server using , I am able to see those packges in SSIS and even manually run them successfully. However, when I schedule them to run they keep failing.
I am scheduling them as a different user who has sysadmin server role.
I have set the SQLAgentOperatorRole,SQLAgentReadRole,SQLAgentUserRole on the MSDB database.
I do not know if I am setting the options which are required or just an overkill.
One more thing which is intriguing is, even though I deploy the project to MSDB, even though the project deploys successfully, I do not see the list of packages under MSDB database.
Can somebody guide me with the correct steps on this.
March 29, 2009 at 7:12 pm
What error messages are you getting?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 30, 2009 at 5:02 pm
For some strange reason, the job decided to run today. so no issues.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply