Table | jobs |
|---|---|
Description | Jobs |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| co_id | integer, foreign key | CO ID | cos:id | | |
| plugin | varchar(80) | Job plugin entry point model | | ||
| parameters | text | JSON encoded list of parameters to pass to the Job plugin | Although this is a JSON document, native JSON types are not used to facilitate portability | ||
| requeue_interval | integer | Upon successful completion, requeue a new copy of the same Job after this many seconds | |||
| retry_interval | integer | Upon failure, retry the Job after this many seconds | A new copy of the job will be queued, and the original will be placed in failed status | ||
| requeued_from_job_id | integer, foreign key | If this Job was requeued or retried, the original Job | jobs:id | ||
| status | varchar(2) | Job status |
| | |
| assigned_host | varchar(60) | The hostname of the server that has been assigned this Job to process | |||
| assigned_pid | integer | The Process ID (PID) that has been assigned this Job | |||
| 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 | |||
| register_time | timestamp | The time this Job was registered (queued) | |||
| start_after_time | timestamp | The Job will be started no earlier than this time, or null for ASAP | |||
| start_time | timestamp | The time this Job was started | |||
| finish_time | timestamp | The time this Job finished or was terminated | |||
| percent_complete | integer | For In Progress Jobs, percent complete | As defined by the Plugin |