sysdbmaintplans (Transact-SQL)
Collapse the table of content
Expand the table of content

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

Applies to: SQL Server (SQL Server 2008 through current version).
Column nameData typeDescription
plan_iduniqueidentifierDatabase maintenance plan ID.
plan_namesysnameDatabase maintenance plan name.
date_createddatetimeDate the database maintenance plan was created.
ownersysnameOwner of the database maintenance plan.
max_history_rowsintMaximum number of rows allotted for recording the history of the database maintenance plan in the system table.
remote_history_serversysnameName of the remote server to which the history report could be written.
max_remote_history_rowsintMaximum number of rows allotted in the system table on a remote server to which the history report could be written.
user_defined_1intDefault is NULL.
user_defined_2nvarchar(100)Default is NULL.
user_defined_3datetimeDefault is NULL.
user_defined_4uniqueidentifierDefault is NULL.
log_shippingbitLog shipping status:

 0 = Disabled 1 = Enabled

Community Additions

© 2016 Microsoft