Contains information about the execution of scheduled jobs by SQL Server Agent. This table is stored in the msdb database.
Unique identifier for the row.
ID of the step in the job.
Name of the step.
ID of any SQL Server error message returned if the job failed.
Severity of any SQL Server error.
Text, if any, of a SQL Server error.
Status of the job execution:
0 = Failed
1 = Succeeded
2 = Retry
3 = Canceled
4 = In progress
Date the job or step started execution. For an In Progress history, this is the date/time the history was written.
Time the job or step started.
Elapsed time in the execution of the job or step in HHMMSS format.
ID of the operator notified when the job completed.
ID of the operator notified by a message when the job completed.
ID of the operator notified by pager when the job completed.
Number of retry attempts for the job or step.
Name of the server where the job was executed.