sysdbmaintplan_history (Transact-SQL)


Updated: June 10, 2016

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 nameData typeDescription
sequence_idintSequence of history performed by database maintenance plans.
plan_iduniqueidentifierDatabase maintenance plan ID.
plan_namesysnameDatabase maintenance plan name.
database_namesysnameName of the database associated with the database maintenance plan.
server_namesysnameSystem name.
activitynvarchar(128)Activity performed by the database maintenance plan (for example, Backup transaction log, and so on.).
succeededbit0 = Success 1 = Failure
end_timedatetimeTime at which action completed.
durationintLength of time required to complete database maintenance plan action.
start_timedatetimeTime at which action began.
error_numberintError number reported on failure.
messagenvarchar(512)Message generated by sqlmaint.

Community Additions