Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Database Maintenance Plan Tables (Transact-SQL)

Database Maintenance Plan Tables (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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.

System_CAPS_noteNote

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.

Community Additions

ADD
Show:
© 2015 Microsoft