quartz表删除顺序

最新推荐文章于 2023-09-18 17:31:32 发布

无名小仙男

最新推荐文章于 2023-09-18 17:31:32 发布

阅读量2.1k

点赞数 9

文章标签： java

本文链接：https://blog.csdn.net/zxl8876/article/details/114025539

版权

quartz框架用到的表，删除顺序

有些博客，是真的坑爹，写了一堆删除语句根本删除不了！！！
我自己又花时间重新整理了一遍。。上干货

DELETE FROM `QRTZ_LOCKS`;
DELETE FROM `QRTZ_CALENDARS`;
DELETE FROM `QRTZ_FIRED_TRIGGERS`;
DELETE FROM `QRTZ_PAUSED_TRIGGER_GRPS`;
DELETE FROM `QRTZ_SCHEDULER_STATE`;
DELETE FROM `QRTZ_BLOB_TRIGGERS`;
DELETE FROM `QRTZ_CRON_TRIGGERS`;
DELETE FROM `QRTZ_SIMPLE_TRIGGERS`;
DELETE FROM `QRTZ_SIMPROP_TRIGGERS`;
DELETE FROM `QRTZ_TRIGGERS`;
DELETE FROM `QRTZ_JOB_DETAILS`;