转自http://www.bubuko.com/infodetail-2972288.html
DELETE FROM `QRTZ_LOCKS`;
DELETE FROM `QRTZ_PAUSED_TRIGGER_GRPS`;
DELETE FROM `QRTZ_SCHEDULER_STATE`;
DELETE FROM `QRTZ_CALENDARS`;
DELETE FROM `QRTZ_JOB_DETAILS`;
DELETE FROM `QRTZ_TRIGGERS`;
DELETE FROM `QRTZ_BLOB_TRIGGERS`;
DELETE FROM `QRTZ_CRON_TRIGGERS`;
DELETE FROM `QRTZ_SIMPLE_TRIGGERS`;
DELETE FROM `QRTZ_SIMPROP_TRIGGERS`;
DELETE FROM `QRTZ_FIRED_TRIGGERS`;

本文提供了一套完整的SQL语句,用于清除Quartz调度器在数据库中存储的所有任务、触发器及相关信息,适用于系统重启或初始化场景。
3万+

被折叠的 条评论
为什么被折叠?



