Edit

sysdbmaintplan_history (Transact-SQL)

  • Article

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.