dbo.sysjobhistory (Transact-SQL)
Contains information about the execution of scheduled jobs by SQL Server Agent. This table is stored in the msdb database.
Note
Data is updated only after the jobstep completes.
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(4000) |
Text, if any, of a SQL Server error. |
run_status |
int |
Status of the job execution: 0 = Failed 1 = Succeeded 2 = Retry 3 = Canceled |
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. |