CSO_QRTZ_FIRED_TRIGGERS
This table is only used by the Quartz Scheduler.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_QRTZ_FIRED_TRIGGERS_PK |
SCHED_NAME, ENTRY_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ENTRY_ID | VARCHAR2 | 95 | Yes | This is the Quartz supplied Id for this record. |
| TRIGGER_NAME | VARCHAR2 | 200 | Yes | This is the Trigger name for this record. |
| TRIGGER_GROUP | VARCHAR2 | 200 | Yes | This is the Name that associates trigger. The reference key of the repository that the trigger belongs to |
| INSTANCE_NAME | VARCHAR2 | 200 | Yes | This is the Scheduler instance name. |
| FIRED_TIME | NUMBER | Yes | This is the Time job was fired for this record. | |
| PRIORITY | NUMBER | Yes | This is the comment for the column PRIORITY. | |
| STATE | VARCHAR2 | 16 | Yes | This is the state of the job for this record. |
| JOB_NAME | VARCHAR2 | 200 | This is the name of the job that was fired. | |
| JOB_GROUP | VARCHAR2 | 200 | This is the Name that associates job The reference key of the repository that the job belongs to | |
| IS_NON_CONCURRENT | VARCHAR2 | 1 | Column that replaced is_stateful column in quartz-2.2.x version. | |
| SCHED_TIME | NUMBER | Yes | new column added in quartz-2.2.x version for next triggers to fire. | |
| REQUESTS_RECOVERY | VARCHAR2 | 1 | Indicates whether the job should be re-executed in case of a recovery situation. | |
| SCHED_NAME | VARCHAR2 | 120 | Yes | Added a new column in quartz-2.2.x version. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CSO_QRTZ_FIRED_TRIGGERS_U1 | Unique | SCHED_NAME, ENTRY_ID |
| CSO_QRTZ_FIRED_TRIGGERS_N1 | Non Unique | SCHED_NAME, JOB_GROUP |
| CSO_QRTZ_FIRED_TRIGGERS_N2 | Non Unique | SCHED_NAME, JOB_NAME, JOB_GROUP |
| CSO_QRTZ_FIRED_TRIGGERS_N3 | Non Unique | SCHED_NAME, INSTANCE_NAME, REQUESTS_RECOVERY |
| CSO_QRTZ_FIRED_TRIGGERS_N4 | Non Unique | SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP |
| CSO_QRTZ_FIRED_TRIGGERS_N6 | Non Unique | SCHED_NAME, TRIGGER_GROUP |