July 3, 2012 at 11:00 am
One of my DTS Package Maintance Plan is getting fail. I investigated the job owner is having full permission and existed eventhough it is failing...
Kindly what is the route cause to investigate and how to monitor this maintance plan.
Thanks in advance....
August 1, 2012 at 4:39 am
The maintenance jobs will run using the SQL Agent account. So if your maintenance plan is dealing with network resources (e.g. saving backups to a remote server) then make sure that the SQL Agent runs using a domain account that has permissions on both your databases and the remote location. You should also check the "msdb.dbo.sysmainthistory" table to see if there is more information on why the plan is failing.
August 2, 2012 at 2:16 am
your running the maintenance plan via sql agent right? what does the job history say?
August 2, 2012 at 2:40 am
clieck the job and view history, then post this info here.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply