---
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: "stevestein"
ms.author: "sstein"
---
# sysdbmaintplan_history (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

  This table is stored in the **msdb** database.  
  
 [!INCLUDE[ssNoteDepNextAvoid](../../includes/ssnotedepnextavoid-md.md)]  
  
  
|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**.|