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(4000) | 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. | |
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_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 |