Skip to content

Instantly share code, notes, and snippets.

@flozano

flozano/quartz-snippets.md

Created April 27, 2023 09:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save flozano/a8dc60e2e7c3497b79b3285ec1b135fe to your computer and use it in GitHub Desktop.
Save flozano/a8dc60e2e7c3497b79b3285ec1b135fe to your computer and use it in GitHub Desktop.
Download ZIP
Quartz snippets
Raw
quartz-snippets.md

Force execution

update QRTZ_TRIGGERS set next_fire_time = (select unix_timestamp(date_add(now(), interval 1 minute)) * 1000) where job_name = 'myJob';

Pause execution of a trigger

UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = 'PAUSED' WHERE JOB_NAME='myJob';
UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = 'WAITING' WHERE JOB_NAME='myJob';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment