Level: Critical

Purpose: Checks the quartz table for each application to see if there are any blocked jobs.

select * from QRTZ_CLUSTER_TRIGGERS where TRIGGER_STATE = 'BLOCKED';

Scenario: For various reasons, a job can block. This job will need to be restarted.

Resolution: Restart quartz job

Manual Action Steps:

update QRTZ_CLUSTER_TRIGGERS set NEXT_FIRE_TIME = (UNIX_TIMESTAMP(date_add(now(), interval 30 second))*1000), TRIGGER_STATE = 'WAITING' where TRIGGER_STATE  = 'BLOCKED';

If the above doesn't work, check the logs for errors for that job. Sometimes disabling and reenabling the job works.

select * from config_store cs;

Auto Clear: Yes