如何清空Quartz表的数据

  Quartz
  定时任务
2
0
0
字数:431
博主: 勤勇学
发布于: 2024-08-02 00:13:19
原创声明:文章所有权为创作者【原创】所有,未经许可,不得转载!
目录
未发现目录

当Quartz的表数据存在问题时,想清除数据,可以按照以下清除顺序进行数据清除(Tip: 表名可能大小写敏感,请自己更改表名

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`;

目录
未发现目录