Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
clear quartz database: mysql
SET FOREIGN_KEY_CHECKS=0;
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`;
SET FOREIGN_KEY_CHECKS=0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment