sysdbmaintplans-transact-sql.md

title	sysdbmaintplans (Transact-SQL)
description	sysdbmaintplans (Transact-SQL)
author	VanMSFT
ms.author	vanto
ms.date	06/10/2016
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	sysdbmaintplans_TSQL sysdbmaintplans
helpviewer_keywords	sysdbmaintplans system table
dev_langs	TSQL

sysdbmaintplans (Transact-SQL)

[!INCLUDE SQL Server]

This table is included in [!INCLUDEmsCoName] [!INCLUDEssNoVersion] to preserve existing information for instances upgraded from a previous version of [!INCLUDEmsCoName] [!INCLUDEssNoVersion]. [!INCLUDEssNoVersion] does not change the contents of this table. This table is stored in the msdb database.

[!INCLUDEssNoteDepFutureAvoid]

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