Table | cm_co_jobs |
|---|---|
Description | Per-CO Job Records |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | |
co_id | integer, foreign key | CO Record ID | cm_cos:id | |
job_type | varchar(32) | Job Type |
| Plugin name added as of Registry v3.3.0. Enum style values deprecated, will be removed in v4.0.0 |
| job_type_fk | integer | Foreign key value associated with Job Type | eg: cm_org_identity_sources:id Deprecated, will be removed in Registry v4.0.0 | |
| job_mode | varchar(16) | Job Type-specific mode | ||
| job_params | text | JSON encoded list of parameters to pass to the Job plugin | Added in Registry v3.3.0 Although this is a json document, native json types are not used since they are only available in relatively new versions of the RDBMSs. Also, ADOdb schema support for the json type is limited. | |
| requeue_interval | integer | Upon successful completion, requeue a new copy of the same job after this many seconds | Added in Registry v4.0.0 | |
| retry_interval | integer | Upon failure, retry the job after this many seconds | Added in Registry v4.0.0 A new copy of the job will be queued, and the original will be placed in failed status. | |
| max_retry | integer | Maximum retries for this Job | Added in Registry v4.3.0 | |
| max_retry_count | integer | Retry count | Added in Registry v4.3.0 | |
| requeued_from_co_job_id | integer, foreign key | If this is a requeue or retry job, the original job | cm_co_jobs:id | Added in Registry v4.0.0 |
status | varchar(2) | Job Status |
| |
| register_summary | varchar(256) | Summary description for status at time of job registration | ||
| start_summary | varchar(256) | Summary description for status at time of job start | ||
| finish_summary | varchar(256) | Summary description for status at time of job completion | ||
| queue_time | timestamp | Time Job was queued | ||
| start_after_time | timestamp | Time Job should be started after, or null for ASAP | Added in Registry v4.0.0 | |
| start_time | timestamp | Time Job was started | ||
| complete_time | timestamp | Time Job was completed | ||
| percent_complete | integer | For In Progress Jobs, percent complete | Added in Registry v3.3.0 |