| Field | Nullable | Data type | Constraint | Unique Constraint | Description |
|---|
ID | NOT NULL | NUMERIC | Primary Key | | |
INSTANCE_ID | NOT NULL | NUMERIC | Foreign Key | X | references INVENTORY_INSTANCES.ID |
FILE_ID | NOT NULL | NUMERIC | Foreign Key | | references INVENTORY_FILES.ID |
PROCESS_CLASS_ID | NOT NULL | NUMERIC | Foreign Key | | references INVENTORY_PROCESS_CLASSES.ID |
SCHEDULE_ID | NOT NULL | NUMERIC | Foreign Key | | references INVENTORY_SCHEDULES.ID |
NAME | NOT NULL | VARCHAR | | | job name e.g. /test/my_job for a given job path /test/my_job.job.xml
|
BASENAME | NOT NULL | VARCHAR | | | job base name e.g. my_job for a given job path /test/my_job.job.xml |
TITLE | NULL | VARCHAR | | | job title |
IS_ORDER_JOB
| NOT NULL | NUMERIC | | | specifies if this job is part of a job chain: |
IS_RUNTIME_DEFINED
| NOT NULL | NUMERIC | | | specifies if a start time has been configured: |
USED_IN_JOB_CHAINS | | NUMERIC | | | |
PROCESS_CLASS | | VARCHAR | | | |
PROCESS_CLASS_NAME | NOT NULL | VARCHAR | | | corresponds to INVENTORY_PROCESS_CLASSES.NAME |
SCHEDULE | | VARCHAR | | | |
SCHEDULE_NAME | NOT NULL | VARCHAR | | | corresponds to INVENTORY_SCHEDULES.NAME |
CREATED | NOT NULL | DATETIME | | | UTC timestamp of record creation |
MODIFIED | NOT NULL | DATETIME | | | UTC timestamp of record modification |