sysdbmaintplans (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 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.

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