CSO_QRTZ_TRIGGERS
This table is only used by the Quartz Scheduler for scheduling batch jobs.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_QRTZ_TRIGGERS_PK |
SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| TRIGGER_NAME | VARCHAR2 | 200 | Yes | This is the Trigger name for this record. |
| TRIGGER_GROUP | VARCHAR2 | 200 | Yes | This is the Name that associates jobs. The reference key of the repository that the job belongs to |
| 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 trigger. | |
| NEXT_FIRE_TIME | NUMBER | This is the next scheduled fire time. | ||
| PREV_FIRE_TIME | NUMBER | This is the Last time job was executed by this trigger. | ||
| PRIORITY | NUMBER | This indicates the priority of the scheduled batch job. | ||
| TRIGGER_STATE | VARCHAR2 | 16 | Yes | This is the state of the trigger. |
| TRIGGER_TYPE | VARCHAR2 | 8 | Yes | This is the type of trigger, such as “SIMPLE", "CRON", or "BLOB". |
| START_TIME | NUMBER | Yes | Time the trigger will start executing the job | |
| END_TIME | NUMBER | Time the trigger will stop executing the job | ||
| CALENDAR_NAME | VARCHAR2 | 200 | This is the Name of quartz calendar to use. | |
| MISFIRE_INSTR | NUMBER | Tells quartz how the trigger will try to reschedule job in a misfire situation. | ||
| JOB_DATA | BLOB | This provides additional data to be be provided to the job at execution time. | ||
| SCHED_NAME | VARCHAR2 | 120 | Yes | The name for the given schedule. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_QRTZ_TRIGGERS | cso_qrtz_job_details | SCHED_NAME, JOB_NAME, JOB_GROUP |
| cso_qrtz_blob_triggers | cso_qrtz_triggers | SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP |
| cso_qrtz_simple_triggers | cso_qrtz_triggers | SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP |
| cso_qrtz_simprop_triggers | cso_qrtz_triggers | SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP |
| cso_qrtz_cron_triggers | cso_qrtz_triggers | SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CSO_QRTZ_TRIGGERS_N10 | Non Unique | Default | SCHED_NAME, MISFIRE_INSTR, NEXT_FIRE_TIME, TRIGGER_GROUP, TRIGGER_STATE | |
| CSO_QRTZ_TRIGGERS_N11 | Non Unique | Default | SCHED_NAME, JOB_NAME, JOB_GROUP | |
| CSO_QRTZ_TRIGGERS_N12 | Non Unique | Default | SCHED_NAME, JOB_GROUP | |
| CSO_QRTZ_TRIGGERS_N2 | Non Unique | Default | SCHED_NAME, NEXT_FIRE_TIME, TRIGGER_STATE | |
| CSO_QRTZ_TRIGGERS_N3 | Non Unique | Default | SCHED_NAME, TRIGGER_STATE | |
| CSO_QRTZ_TRIGGERS_N4 | Non Unique | Default | SCHED_NAME, CALENDAR_NAME | |
| CSO_QRTZ_TRIGGERS_N6 | Non Unique | Default | SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_STATE | Obsolete |
| CSO_QRTZ_TRIGGERS_N7 | Non Unique | Default | SCHED_NAME, TRIGGER_GROUP, TRIGGER_STATE | |
| CSO_QRTZ_TRIGGERS_N9 | Non Unique | Default | SCHED_NAME, MISFIRE_INSTR, NEXT_FIRE_TIME, TRIGGER_STATE | |
| CSO_QRTZ_TRIGGERS_U1 | Unique | Default | SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP |