patternMinor
Location of Maintenance Plan's Back Up Database Tasks information (SQL Server 2005)
Viewed 0 times
sqldatabaseplanmaintenancebacktasks2005serverlocationinformation
Problem
I would like to know where in the database or on the file system the information about Back Up Database Task in the Maintenance Plans Tasks.
I can find the Job in msdb.dbo.sysjobs
I can find the Subplan in msdb.dbo.sysmaintplan_subplans
But I need to find where and how the Task is being stored.
Any help will be greatly appreciated.
I can find the Job in msdb.dbo.sysjobs
I can find the Subplan in msdb.dbo.sysmaintplan_subplans
But I need to find where and how the Task is being stored.
Any help will be greatly appreciated.
Solution
In SQL 2000 they were in the msdb database.
Specific table information can be found here:
http://www.toadworld.com/platforms/sql-server/w/wiki/9438.msdb-databases.aspx#Database_Maintenance_Plan_Tables
In SQL 2005 maintenance plans are modified SSIS (or DTS) packages and are stored in the dbo.sysdtspackages90 table. (from: http://www.sqlservercentral.com/Forums/Topic501078-5-1.aspx )
In SQL 2008 and 2012 they are in the sysssispackages table.
Specific table information can be found here:
http://www.toadworld.com/platforms/sql-server/w/wiki/9438.msdb-databases.aspx#Database_Maintenance_Plan_Tables
In SQL 2005 maintenance plans are modified SSIS (or DTS) packages and are stored in the dbo.sysdtspackages90 table. (from: http://www.sqlservercentral.com/Forums/Topic501078-5-1.aspx )
In SQL 2008 and 2012 they are in the sysssispackages table.
Context
StackExchange Database Administrators Q#2651, answer score: 6
Revisions (0)
No revisions yet.