-- ----------------------------
|
-- 9、 存储少量的有关 Scheduler 的状态信息，假如是用于集群中，可以看到其他的 Scheduler 实例
|
-- ----------------------------
|
DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;
|
|
CREATE TABLE QRTZ_SCHEDULER_STATE
|
(
|
sched_name VARCHAR(120) NOT NULL, -- 调度名称
|
instance_name VARCHAR(200) NOT NULL, -- 实例名称
|
last_checkin_time BIGINT NOT NULL, -- 上次检查时间
|
checkin_interval BIGINT NOT NULL, -- 检查间隔时间
|
PRIMARY KEY (sched_name, instance_name) -- 主键
|
);
|
|
COMMENT ON TABLE QRTZ_SCHEDULER_STATE IS '调度器状态表';
|
COMMENT ON COLUMN QRTZ_SCHEDULER_STATE.sched_name IS '调度名称';
|
COMMENT ON COLUMN QRTZ_SCHEDULER_STATE.instance_name IS '实例名称';
|
COMMENT ON COLUMN QRTZ_SCHEDULER_STATE.last_checkin_time IS '上次检查时间';
|
COMMENT ON COLUMN QRTZ_SCHEDULER_STATE.checkin_interval IS '检查间隔时间';
|
