QRTZ_BLOB_TRIGGERS Table

Added in Version 8.0

The QRTZ_BLOB_TRIGGERS table contains information used by the Job Service.  

Legend
 

Field Datatype (Length) Allow Nulls Indexes Relationship Related Table and Field

SCHED_NAME

varchar(100)

NOT NULL

 

 

Per PZ: not going to guess what might be related or FK for quartz QRTZ_CALENDARS.SCHED_NAME

 

QRTZ_CRON_TRIGGERS.SCHED_NAME

 

QRTZ_FIRED_TRIGGERS.SCHED_NAME

 

QRTZ_JOB_DETAILS.SCHED_NAME

 

QRTZ_LOCKS.SCHED_NAME

 

QRTZ_PAUSED_TRIGGER_GRPS.SCHED_NAME

 

QRTZ_SCHEDULER_STATE.SCHED_NAME

 

QRTZ_SIMPLE_TRIGGERS.SCHED_NAME

 

QRTZ_SIMPROP_TRIGGERS.SCHED_NAME

 

QRTZ_TRIGGERS.SCHED_NAME

TRIGGER_NAME

varchar(150)

NOT NULL

 

 

QRTZ_CRON_TRIGGERS.TRIGGER_NAME

 

QRTZ_FIRED_TRIGGERS.TRIGGER_NAME

 

QRTZ_SIMPLE_TRIGGERS.TRIGGER_NAME

 

QRTZ_SIMPROP_TRIGGERS.TRIGGER_NAME

 

QRTZ_TRIGGERS.TRIGGER_NAME

TRIGGER_GROUP

varchar(150)

NOT NULL

 

 

QRTZ_CRON_TRIGGERS.TRIGGER_GROUP

 

QRTZ_FIRED_TRIGGERS.TRIGGER_GROUP

 

QRTZ_PAUSED_TRIGGER_GRPS.TRIGGER_GROUP

 

QRTZ_SIMPLE_TRIGGERS.TRIGGER_GROUP

 

QRTZ_SIMPROP_TRIGGERS.TRIGGER_GROUP

 

QRTZ_TRIGGERS.TRIGGER_GROUP

BLOB_DATA

image(16)

NULLS