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(1024)	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.