This topic has not yet been rated - Rate this topic

Database Maintenance Plan Tables (Transact-SQL)

SQL Server 2008 R2

The topics in this section describe the system tables that store information used by database maintenance plans. These tables preserve information for instances that are upgraded from an earlier version of SQL Server.

Note
This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

In This Section

sysdbmaintplan_databases: Contains one row for each database that has an associated upgraded database maintenance plan.
sysdbmaintplan_history: Contains one row for each upgraded database maintenance plan action performed.
sysdbmaintplan_jobs: Contains one row for each upgraded database maintenance plan job.
sysdbmaintplans: Contains one row for each upgraded database maintenance plan.

Concepts

Maintenance Plans

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD