How can I disable jobs in the Quartz JDBCJobStore?

Question

What is the best way to disable a job in the JDBCJobStore without deleting it's job or trigger records and without wiping the cron expression?

Answer 1

Use scheduler.pauseJob() or scheduler.pauseTrigger().

Alternatively you can use the following SQL script:

UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = "PAUSED"

Answer 2

Use the pauseJob or pauseJobGroup methods of JobStore.