Micro Focus Expert
Micro Focus Expert
286 views

(OO) Support Tip: Scheduler jobs are not running on Central

This can happen when there have been node crashes on Central.  As part of the recovery Jobs are created to help recover.  This is done by a 3rd party library called Quartz.

Recovery jobs are created in OO_TRIGGERS table -These jobs can cause blocking in all other quartz internal jobs.

If they do not resolve shortly then they will need to be manually removed from the DB to allow normal processing.

To see if they exist run this query : select TRIGGER_NAME from OO_TRIGGERS;                                                      

These jobs would be in a similar format to :

TRIGGER_NAME=recover_XXXXXXXXXXXXXXXXXXXXXXXXXXX_XXXXXXXXXX                                

Where the xxxx is a random string

If any exist then remove them with a SQL call like this.

delete OO_TRIGGERS where TRIGGER_NAME=''recover_XXXXXXXXXXXXXXXXXXXXXXXXXXX_XXXXXXXXXX’

Where XXXXXXXXXXXXXXXXXXXXXx is the value from the select query above.

This Knowledge article can be found at: https://softwaresupport.softwaregrp.com/group/softwaresupport/search-result/-/facetsearch/document/KM03170821

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.