-- ----------------------------
|
-- 8、 存储与已触发的 Trigger 相关的状态信息，以及相联 Job 的执行信息
|
-- ----------------------------
|
DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;
|
|
CREATE TABLE QRTZ_FIRED_TRIGGERS
|
(
|
sched_name VARCHAR(120) NOT NULL, -- 调度名称
|
entry_id VARCHAR(95) NOT NULL, -- 调度器实例id
|
trigger_name VARCHAR(200) NOT NULL, -- qrtz_triggers表trigger_name的外键
|
trigger_group VARCHAR(200) NOT NULL, -- qrtz_triggers表trigger_group的外键
|
instance_name VARCHAR(200) NOT NULL, -- 调度器实例名
|
fired_time BIGINT NOT NULL, -- 触发的时间
|
sched_time BIGINT NOT NULL, -- 定时器制定的时间
|
priority INTEGER NOT NULL, -- 优先级
|
state VARCHAR(16) NOT NULL, -- 状态
|
job_name VARCHAR(200), -- 任务名称
|
job_group VARCHAR(200), -- 任务组名
|
is_nonconcurrent VARCHAR(1), -- 是否并发
|
requests_recovery VARCHAR(1), -- 是否接受恢复执行
|
PRIMARY KEY (sched_name, entry_id) -- 主键
|
);
|
|
COMMENT ON TABLE QRTZ_FIRED_TRIGGERS IS '已触发的触发器表';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.sched_name IS '调度名称';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.entry_id IS '调度器实例id';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.trigger_name IS 'qrtz_triggers表trigger_name的外键';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.trigger_group IS 'qrtz_triggers表trigger_group的外键';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.instance_name IS '调度器实例名';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.fired_time IS '触发的时间';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.sched_time IS '定时器制定的时间';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.priority IS '优先级';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.state IS '状态';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.job_name IS '任务名称';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.job_group IS '任务组名';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.is_nonconcurrent IS '是否并发';
|
COMMENT ON COLUMN QRTZ_FIRED_TRIGGERS.requests_recovery IS '是否接受恢复执行';
|
