sysdbmaintplans (Transact-SQL)
Applies to: 
SQL Server
This table is included in Microsoft SQL Server to preserve existing information for instances upgraded from a previous version of Microsoft SQL Server. SQL Server does not change the contents of this table. This table is stored in the msdb database.
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
| Column name | Data type | Description |
|---|---|---|
| plan_id | uniqueidentifier | Database maintenance plan ID. |
| plan_name | sysname | Database maintenance plan name. |
| date_created | datetime | Date the database maintenance plan was created. |
| owner | sysname | Owner of the database maintenance plan. |
| max_history_rows | int | Maximum number of rows allotted for recording the history of the database maintenance plan in the system table. |
| remote_history_server | sysname | Name of the remote server to which the history report could be written. |
| max_remote_history_rows | int | Maximum number of rows allotted in the system table on a remote server to which the history report could be written. |
| user_defined_1 | int | Default is NULL. |
| user_defined_2 | nvarchar(100) | Default is NULL. |
| user_defined_3 | datetime | Default is NULL. |
| user_defined_4 | uniqueidentifier | Default is NULL. |
| log_shipping | bit | Log shipping status: 0 = Disabled 1 = Enabled |