Job state codes

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.