Job state codes

The following table defines the job state codes that are returned in the history table.

Table 4-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

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.