Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft