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