# `qrtz_scheduler_state`

> 存储集群中note实例信息，quartz会定时读取该表的信息判断集群中每个实例的当前状态


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

## Columns

| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | `SCHED_NAME` | `varchar(120)` | NO | PRI |  |  | 调度名称 |
| 2 | `INSTANCE_NAME` | `varchar(200)` | NO | PRI |  |  | 之前配置文件中org.quartz.scheduler.instanceId配置的名字，就会写入该字段 |
| 3 | `LAST_CHECKIN_TIME` | `bigint` | NO |  |  |  | 上次检查时间 |
| 4 | `CHECKIN_INTERVAL` | `bigint` | NO |  |  |  | 检查间隔时间 |

## Indexes

| Name | Unique | Type | Columns |
|---|---|---|---|
| `PRIMARY` | ✓ | BTREE | `SCHED_NAME`, `INSTANCE_NAME` |

## 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._
