如何清空或初始化quartz定时相关表时报外键引用错误
原创 2021-06-02 18:18 阅读(2615)次
清空quartz定时相关表时会报外键引用错误
表列表如下：
外键引用错误就需要根据外键关系删除定时表数据，有外键关联的表和顺序如下：
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 阅读(2355)次
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 ...