| title | Database Maintenance Plan Tables (Transact-SQL) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 03/14/2017 | |||
| ms.prod | sql | |||
| ms.prod_service | database-engine | |||
| ms.reviewer | ||||
| ms.technology | system-objects | |||
| ms.topic | language-reference | |||
| dev_langs |
|
|||
| helpviewer_keywords |
|
|||
| ms.assetid | f264554c-5514-4df2-aadb-6dcdc2dfcfea | |||
| author | stevestein | |||
| ms.author | sstein | |||
| manager | craigg |
[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]
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 [!INCLUDEssNoVersion].
Note
[!INCLUDEssNoteDepNextAvoid]
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.