Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |