The following table defines the job state codes that are returned
in the history table.
Table A-1: Job state
codes descriptions
State name
|
State code
|
Description
|
waiting
|
W
|
An initial state for a job that has been
created or is waiting to schedule.
|
queued
|
Q
|
The job scheduler can run the job, may
be waiting for a free thread to run it.
|
busy
|
B
|
The job scheduler did not start the job
because this job was already running.
|
runable
|
R1
|
The job scheduler has begun to start
the job.
|
running
|
R2
|
The job has been started.
|
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
|
The job scheduler has terminated the
job. Post- processing SQL is complete.
|
timing-out
|
X1
|
The job has timed out and the 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.
|