清空quartz数据库

表顺序如下:

delete from qrtz_CRON_TRIGGERS where 1=1;
delete from qrtz_SIMPLE_TRIGGERS where 1=1;
delete from qrtz_TRIGGERS where 1=1;
delete from qrtz_JOB_DETAILS where 1=1;
delete from qrtz_FIRED_TRIGGERS where 1=1;
delete from qrtz_LOCKS where 1=1;
delete from qrtz_SCHEDULER_STATE where 1=1;

delete from qrtz_BLOB_TRIGGERS where 1=1;
delete from qrtz_CALENDARS where 1=1;
delete from qrtz_PAUSED_TRIGGER_GRPS where 1=1;
delete from qrtz_SIMPROP_TRIGGERS where 1=1;

或者:

SET FOREIGN_KEY_CHECKS=0;
DELETE FROM `qrtz_locks` where 1=1;
DELETE FROM `qrtz_paused_trigger_grps` where 1=1;
DELETE FROM `qrtz_scheduler_state` where 1=1;
DELETE FROM `qrtz_calendars` where 1=1;
DELETE FROM `qrtz_job_details` where 1=1;
DELETE FROM `qrtz_triggers` where 1=1;
DELETE FROM `qrtz_blob_triggers` where 1=1;
DELETE FROM `qrtz_cron_triggers` where 1=1;
DELETE FROM `qrtz_simple_triggers` where 1=1;
DELETE FROM `qrtz_simprop_triggers` where 1=1;
DELETE FROM `qrtz_fired_triggers` where 1=1;
SET FOREIGN_KEY_CHECKS=0;

Leave a Reply

Your email address will not be published. Required fields are marked *