Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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. |