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.