如何清空Quartz表的数据
Quartz
定时任务
2
0
0
字数:431
原创声明:文章所有权为创作者【原创】所有,未经许可,不得转载!
目录
未发现目录
当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`;
目录
未发现目录