sysdbmaintplan-history-transact-sql.md

title	sysdbmaintplan_history (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sysdbmaintplan_history_TSQL sysdbmaintplan_history
dev_langs	TSQL
helpviewer_keywords	sysdbmaintplan_history system table
ms.assetid	02d36f08-ac93-4463-bb59-284c5cd6ed04
author	CarlRabeler
ms.author	carlrab

sysdbmaintplan_history (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

This table is stored in the msdb database.

[!INCLUDEssNoteDepNextAvoid]

Column name	Data type	Description
sequence_id	int	Sequence of history performed by database maintenance plans.
plan_id	uniqueidentifier	Database maintenance plan ID.
plan_name	sysname	Database maintenance plan name.
database_name	sysname	Name of the database associated with the database maintenance plan.
server_name	sysname	System name.
activity	nvarchar(128)	Activity performed by the database maintenance plan (for example, Backup transaction log, and so on.).
succeeded	bit	0 = Success 1 = Failure
end_time	datetime	Time at which action completed.
duration	int	Length of time required to complete database maintenance plan action.
start_time	datetime	Time at which action began.
error_number	int	Error number reported on failure.
message	nvarchar(512)	Message generated by sqlmaint.