sysdbmaintplan_history (Transact-SQL)
Applies to: 
SQL Server
This table is stored in the msdb database.
This feature will be removed in a future version of 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 |
|---|---|---|
| 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. |