sysdbmaintplan_history (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This table is stored in the msdb database.

This feature will be removed in the next version of Microsoft 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.