Skip to content

Instantly share code, notes, and snippets.

@ilaipi

ilaipi/clear-quartz-mysql.sql

Created January 12, 2021 15:15
Show Gist options
  • Save ilaipi/b6a8a875085267b065c906d4852c0451 to your computer and use it in GitHub Desktop.
Save ilaipi/b6a8a875085267b065c906d4852c0451 to your computer and use it in GitHub Desktop.
Download ZIP
clear quartz database: mysql
Raw
clear-quartz-mysql.sql
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