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. |
