=====Quartz Job Inactive=====

**Level:** __Critical__ FIXME


**Purpose:**
Checks the quartz table for each application to see if there are any blocked jobs.
<code>select * from QRTZ_CLUSTER_TRIGGERS where TRIGGER_STATE = 'BLOCKED';</code>

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

**Resolution:**
Restart quartz job

**Manual Action Steps:**
<code>update QRTZ_CLUSTER_TRIGGERS set NEXT_FIRE_TIME = (UNIX_TIMESTAMP(date_add(now(), interval 30 second))*1000), TRIGGER_STATE = 'WAITING' where TRIGGER_STATE  = 'BLOCKED';</code>
If the above doesn't work, check the logs for errors for that job.

**Auto Clear:**
Yes