FUN_QRTZ_BLOB_TRIGGERS

This table is used to store triggers as blobs (this is used when Quartz users create their own custom trigger types with JDBC, JobStore does not have specific knowledge about how to store instances).

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FUN_QRTZ_BLOB_TRIGGERS_PK

SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP

Columns

Name Datatype Length Precision Not-null Comments
TRIGGER_NAME VARCHAR2 256 Yes Functional name of the quartz trigger.
SCHED_NAME VARCHAR2 120 Yes Name for the given quartz schedule.
TRIGGER_GROUP VARCHAR2 80 Yes Group associated with quartz trigger.
BLOB_DATA BLOB Custom schedule information of the trigger.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
FUN_QRTZ_BLOB_TRIGGERS_U1 Unique Default TRIGGER_NAME, TRIGGER_GROUP
FUN_QRTZ_BLOB_TRIGGERS_U2 Unique Default SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP