sysdbmaintplans (Transact-SQL)

This table is included in Microsoft SQL Server 2005 to preserve existing information for instances upgraded from a previous version of Microsoft SQL Server. SQL Server 2005 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

Note:

Log shipping is not available in database maintenance plans upgraded to SQL Server 2005.