qrtz_triggers.md 3.06 KB

Edit Raw Blame History



qrtz_triggers


存储触发器的cron表达式表


Rows (estimated): 0

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:55:02

Updated: 


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
SCHED_NAME
varchar(120)
NO
PRI


调度名称


2
TRIGGER_NAME
varchar(200)
NO
PRI


触发器的名字


3
TRIGGER_GROUP
varchar(200)
NO
PRI


触发器所属组的名字


4
JOB_NAME
varchar(200)
NO


qrtz_job_details表job_name的外键


5
JOB_GROUP
varchar(200)
NO


qrtz_job_details表job_group的外键


6
DESCRIPTION
varchar(250)
YES


详细描述信息


7
NEXT_FIRE_TIME
bigint
YES


上一次触发时间（毫秒）


8
PREV_FIRE_TIME
bigint
YES


下一次触发时间，默认为-1，意味不会自动触发


9
PRIORITY
int
YES


优先级


10
TRIGGER_STATE
varchar(16)
NO


当前触发器状态，设置为ACQUIRED,如果设置为WAITING,则job不会触发 （ WAITING:等待 PAUSED:暂停ACQUIRED:正常执行 BLOCKED：阻塞 ERROR：错误）


11
TRIGGER_TYPE
varchar(8)
NO


触发器的类型，使用cron表达式


12
START_TIME
bigint
NO


开始时间


13
END_TIME
bigint
YES


结束时间


14
CALENDAR_NAME
varchar(200)
YES


日程表名称，表qrtz_calendars的calendar_name字段外键


15
MISFIRE_INSTR
smallint
YES


措施或者是补偿执行的策略


16
JOB_DATA
blob
YES


一个blob字段，存放持久化job对象


Indexes


Name
Unique
Type
Columns


IDX_QRTZ_T_C

BTREE

SCHED_NAME, CALENDAR_NAME


IDX_QRTZ_T_G

BTREE

SCHED_NAME, TRIGGER_GROUP


IDX_QRTZ_T_J

BTREE

SCHED_NAME, JOB_NAME, JOB_GROUP


IDX_QRTZ_T_JG

BTREE

SCHED_NAME, JOB_GROUP


IDX_QRTZ_T_N_G_STATE

BTREE

SCHED_NAME, TRIGGER_GROUP, TRIGGER_STATE


IDX_QRTZ_T_N_STATE

BTREE

SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_STATE


IDX_QRTZ_T_NEXT_FIRE_TIME

BTREE

SCHED_NAME, NEXT_FIRE_TIME


IDX_QRTZ_T_NFT_MISFIRE

BTREE

SCHED_NAME, MISFIRE_INSTR, NEXT_FIRE_TIME


IDX_QRTZ_T_NFT_ST

BTREE

SCHED_NAME, TRIGGER_STATE, NEXT_FIRE_TIME


IDX_QRTZ_T_NFT_ST_MISFIRE

BTREE

SCHED_NAME, MISFIRE_INSTR, NEXT_FIRE_TIME, TRIGGER_STATE


IDX_QRTZ_T_NFT_ST_MISFIRE_GRP

BTREE

SCHED_NAME, MISFIRE_INSTR, NEXT_FIRE_TIME, TRIGGER_GROUP, TRIGGER_STATE


IDX_QRTZ_T_STATE

BTREE

SCHED_NAME, TRIGGER_STATE


PRIMARY
✓
BTREE

SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP


Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.