drop table qrtz_cron_triggers;
drop table `qrtz_simple_triggers`;
drop table `qrtz_paused_trigger_grps`;
drop table `qrtz_simprop_triggers`;
drop table `qrtz_fired_triggers`;
drop table `qrtz_blob_triggers`;
drop table `qrtz_triggers`;
drop table `qrtz_job_details`;

数据删除顺序

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

表插入顺序

`qrtz_job_details`;
`qrtz_triggers`;
`qrtz_cron_triggers`;
`qrtz_simple_triggers`;