Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS Package Maintance Plan... Expand / Collapse
Author
Message
Posted Tuesday, July 3, 2012 11:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 3:18 AM
Points: 104, Visits: 401

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....
Post #1324529
Posted Wednesday, August 1, 2012 4:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 6, 2014 5:03 AM
Points: 119, Visits: 222
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.
Post #1338415
Posted Thursday, August 2, 2012 2:16 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 4:50 AM
Points: 904, Visits: 1,883
your running the maintenance plan via sql agent right? what does the job history say?
Post #1339001
Posted Thursday, August 2, 2012 2:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:47 AM
Points: 126, Visits: 1,084
clieck the job and view history, then post this info here.

[li][/li]
Post #1339010
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse