Share via


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

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.