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 .gif "Note") Note
Log shipping is not available in database maintenance plans upgraded from SQL Server 2000.
|