sysjobactivity (Transact-SQL)

Records current SQL Server Agent job activity and status.

Column name

Data type

Description

session_id

int

ID of the session stored in the syssessions table in the msdb database.

job_id

uniqueidentifier

ID of the job.

run_requested_date

datetime

Date and time that the job was requested to run.

run_requested_source

sysname(nvarchar(128))

Who requested the job to run.

1 = SOURCE_SCHEDULER

2 = SOURCE_ALERTER

3 = SOURCE_BOOT

4 = SOURCE_USER

6 = SOURCE_ON_IDLE_SCHEDULE

queued_date

datetime

Date and time this job was queued. If the job is run directly, this column is NULL.

start_execution_date

datetime

Date and time job has been scheduled to run.

last_executed_step_id

int

ID of the last job step that ran.

last_executed_step_

date

datetime

Date and time that the last job step began to run.

stop_execution_date

datetime

Date and time that the job finished running.

job_history_id

int

Used to identify a row in the sysjobhistory table.

next_scheduled_run_date

datetime

Next date and time that the job is scheduled to run.

See Also

Reference