FUN_QRTZ_JOB_DETAILS

This table stores detailed information for every configured quartz Job.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FUN_QRTZ_JOB_DETAILS_PK

SCHED_NAME, JOB_NAME, JOB_GROUP

Columns

Name Datatype Length Precision Not-null Comments
SCHED_NAME VARCHAR2 120 Yes Name for the given quartz schedule.
JOB_NAME VARCHAR2 256 Yes Functional name of the quartz job.
JOB_GROUP VARCHAR2 80 Yes Group associated with quartz job.
DESCRIPTION VARCHAR2 120 Stores detailed description of the quartz job.
JOB_CLASS_NAME VARCHAR2 128 Yes Executable associated with the job.
IS_DURABLE VARCHAR2 1 Yes Denotes durability of a job in job store without depending on trigger.
IS_VOLATILE VARCHAR2 1 Denotes persistence of jobs between program shutdown.
IS_STATEFUL VARCHAR2 1 Stores statefulness of the job. If stateful then one job will run at a time.
IS_UPDATE_DATA VARCHAR2 1 Stores if job data can be updated or not.
IS_NONCONCURRENT VARCHAR2 1 Stores concurrency of the job. If non-concurrent then one job will run at a time. Used for cluster coordination purposes and clearing up blocked states.
REQUESTS_RECOVERY VARCHAR2 1 Yes Instructs the Scheduler whether or not the Job should be re-executed if a 'recovery' or 'fail-over' situation is encountered. Fail-over occurs when one of the nodes fails while in the midst of executing one or more jobs. A recovery situation is every situation that produce an 'Hard-shutdown'.
JOB_DATA BLOB Parameters associated to a quartz job.
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_JOB_DETAILS_N1 Non Unique Default REQUESTS_RECOVERY
FUN_QRTZ_JOB_DETAILS_N2 Non Unique Default SCHED_NAME, REQUESTS_RECOVERY
FUN_QRTZ_JOB_DETAILS_N3 Non Unique Default SCHED_NAME, JOB_GROUP
FUN_QRTZ_JOB_DETAILS_U1 Unique Default JOB_NAME, JOB_GROUP
FUN_QRTZ_JOB_DETAILS_U2 Unique Default SCHED_NAME, JOB_NAME, JOB_GROUP