表顺序如下：

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;