Export (0) Print
Expand All

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 Note

Data is updated only after the jobstep completes.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft