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.