搜索:quartz

如何清空或初始化quartz定时相关表时报外键引用错误

原创 2021-06-02 18:18 阅读(86)次
清空quartz定时相关表时会报外键引用错误 表列表如下: ![](http://img.classinstance.cn/20210602/1622626914839.jpg) 外键引用错误就需要根据外键关系删除定时表数据,有外键关联的表和顺序如下: qrtz_cron_triggers qrtz_triggers qrtz_job_details qrtz_fired_triggers 清空表和删除表顺序执行如下语句: ```sql DELETE from qrtz_cron_triggers ; DELETE from qrtz_triggers ; ...

quartz定时器改名后报错,删除多余的定时表数据

原创 2020-09-27 16:55 阅读(500)次
quartz定时器改名后报错,需要清除原来表中的对应数据,删除多余的定时表数据删除语句如下,对应的定时信息要传入:DELETE from qrtz_cron_triggers where TRIGGER_NAME = 'personTimeSpaceTaskTrigger'; DELETE from qrtz_triggers where TRIGGER_NAME = 'personTimeSpaceTaskTrigger'; DELETE from qrtz_job_details where JOB_NAME = 'personTimeSpaceTask'; DELETE from ...