Skip to content

Latest commit

 

History

History
41 lines (35 loc) · 2.09 KB

File metadata and controls

41 lines (35 loc) · 2.09 KB
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