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