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.