How can the databases included in a Maintenance Plan be determined, and how is the PlanID used?
When a Maintenance Plan is created (whether using native SQL Server or LiteSpeed), the plan_id is written to the sysdbmaintplans in msdb, and the names of databases included in plan_id are written to sysdbmaintplan_databases. plan_id is the primary key in sysdbmaintplan_databases, and is visible in the t-sql in the job step of the Maintenance Plan.
As Maintenance Plans are created, databases included in the plan may be verified in the sysdbmaintplan_databases table, or displayed by right-clicking on the Maintenance Plan and selecting "Edit Maintenance Plan" in the Quest Enterprise Console. LiteSpeed Maintenance Plan detail will not be visible via the SQL Server Enterprise Manager.
All Versions of LiteSpeed 4.x
All Versions of SQL Server
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center