The following table defines the job state codes that are returned in the history table.
State name |
State code |
Description |
---|---|---|
waiting |
W |
An initial state for a job that has been created or is waiting to schedule. |
queued |
Q |
Job Scheduler can run the job, but it may be waiting for a free thread to run it. |
busy |
B |
Job Scheduler did not start the job because this job was already running. |
runable |
R1 |
Job Scheduler has started the job. |
running |
R2 |
The job is running. |
completing |
C1 |
The job has completed, and Job Scheduler is cleaning up logs, history, and so on. |
completed |
C2 |
The job has completed. Post-processing SQL is complete. |
terminating |
T1 |
Job Scheduler is terminating the job, killing the thread. |
terminated |
T2 |
Job Scheduler has terminated the job. Post- processing SQL is complete. |
timing-out |
X1 |
The job has timed out, and Job Scheduler is terminating the job. |
timed-out |
X2 |
The job has timed out and been terminated. |
missed |
M |
The scheduled run of the job was missed when Job Scheduler was inactive. |