# `qrtz_triggers`

> 存储触发器的cron表达式表


- **Engine:** InnoDB
- **Collation:** utf8mb3_general_ci

## 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](../../slices/index.md), link from there back to this page._