Differences

This shows you the differences between two versions of the page.

--- resolution_area:watchdog_resolutions:res-w9219 [2021/06/29 17:03] – btobin
+++ resolution_area:watchdog_resolutions:res-w9219 [2022/08/18 10:36] (current) – 10.91.110.100
@@ Line 5: / Line 5: @@
 **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

Internal Errigal Collaboration Wiki