Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

Contains one row for each maintenance plan action performed. This table is stored in the msdb database.

Column name Data type Description
sequence_id int Sequence of history performed by maintenance plans.
plan_id uniqueidentifier Maintenance plan ID.
plan_name sysname Maintenance plan name.
database_name sysname Name of the database associated with the maintenance plan.
server_name sysname System name.
activity nvarchar(128) Activity performed by the 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 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.

© 2016 Microsoft