CSO_QRTZ_JOB_DETAILS
This table is used by the Quartz job scheduler.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_QRTZ_JOB_DETAILS_PK |
SCHED_NAME, JOB_NAME, JOB_GROUP |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| JOB_NAME | VARCHAR2 | 200 | Yes | This is the Job name for this record. |
| JOB_GROUP | VARCHAR2 | 200 | Yes | This is the Name that associates jobs. The reference key of the repository that the job belongs to |
| DESCRIPTION | VARCHAR2 | 250 | This is the Description of the Quartz job. | |
| JOB_CLASS_NAME | VARCHAR2 | 250 | Yes | Full class name that Quartz will use to dynamically create. Must implement the org.quartz.Job |
| IS_DURABLE | VARCHAR2 | 1 | Yes | Flag indicating of the job is stored in the database. |
| IS_NON_CONCURRENT | VARCHAR2 | 1 | Yes | Column that replaced is_stateful column in quartz-2.2.x version. |
| IS_UPDATE_DATA | VARCHAR2 | 1 | Yes | Column that replaced is_stateful column in quartz-2.2.x version. |
| REQUESTS_RECOVERY | VARCHAR2 | 1 | Yes | Indicates whether the job should try to be re-executed in case of a recovery situation. |
| JOB_DATA | BLOB | Contains the serialized JobDataMap holding the specific parameters that the job was set up with | ||
| SCHED_NAME | VARCHAR2 | 120 | Yes | Added a new column in quartz-2.2.x version. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| cso_qrtz_triggers | cso_qrtz_job_details | SCHED_NAME, JOB_NAME, JOB_GROUP |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CSO_QRTZ_JOB_DETAILS_U1 | Unique | SCHED_NAME, JOB_NAME, JOB_GROUP |
| CSO_QRTZ_JOB_DETAILS_N1 | Non Unique | SCHED_NAME, REQUESTS_RECOVERY |
| CSO_QRTZ_JOB_DETAILS_N2 | Non Unique | SCHED_NAME, JOB_GROUP |