Database Table: Job Status

The Job Status table, STATJOB, stores the job status information.

This table has the following columns:

AUTO_REP_VERSION

Includes the automatic increment counter used by the replication engine for comparing the values before and after the update.

JDOMID

Includes the job domain ID.

JOBID

Includes the Job ID

OBJECT_DOMAIN_UUID

Includes the object domain UUID used for replication.

OBJECT_TYPE

Includes the type of object.

Example: ca_discovered_hardware=1, ca_discovered_user=2.

OBJECT_UUID

Includes the object UUID. This column has a foreign key to either ca_discovered_hardware or ca_discovered_user depending on the object_type.

STATUS

Includes the job status.

STCOUNT

Includes the number of times the job has been executed.

STDATE

Includes the date of last status update.

STELAPSE

Includes the elapsed time for the last execution of the job (in seconds).

STFLAG

Indicates whether status text is required.

Example: 0=None,1=More

STQCOUNT

Includes the number of times the job has been cancelled.

STREV

Includes the revisions number

STTEXT

Includes the status text. This column can contain up to 127 characters.

More information: