sysjobhistory (Transact-SQL)
Contains information about the execution of scheduled jobs by SQL Server Agent. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
instance_id |
int |
Unique identifier for the row. |
job_id |
uniqueidentifier |
Job ID. |
step_id |
int |
ID of the step in the job. |
step_name |
sysname |
Name of the step. |
sql_message_id |
int |
ID of any SQL Server error message returned if the job failed. |
sql_severity |
int |
Severity of any SQL Server error. |
message |
nvarchar(1024) |
Text, if any, of a SQL Server error. |
run_status |
int |
Status of the job execution: 0 = Failed 1 = Succeeded 2 = Retry 3 = Canceled 4 = In progress |
run_date |
int |
Date the job or step started execution. For an In Progress history, this is the date/time the history was written. |
run_time |
int |
Time the job or step started. |
run_duration |
int |
Elapsed time in the execution of the job or step in HHMMSS format. |
operator_id_emailed |
int |
ID of the operator notified when the job completed. |
operator_id_netsent |
int |
ID of the operator notified by a message when the job completed. |
operator_id_paged |
int |
ID of the operator notified by pager when the job completed. |
retries_attempted |
int |
Number of retry attempts for the job or step. |
server |
sysname |
Name of the server where the job was executed. |