Fixing the Infor CRM Job Manager when all Jobs are Stuck “Paused”

In Infor CRM version 8.3.06 the Job Service can get stuck in Paused Mode. This is Fixed in version 8.3.08 and higher.

If you run into this issue where all the jobs are stuck you can follow these steps to fix it:

• Shut down the Saleslogix Cache service
• Shut down the Saleslogix Job service
• Run these scripts

DELETE FROM sysdba.QRTZ_BLOB_TRIGGERS

DELETE FROM sysdba.QRTZ_CALENDARS

DELETE FROM sysdba.QRTZ_CRON_TRIGGERS

DELETE FROM sysdba.QRTZ_FIRED_TRIGGERS

DELETE FROM sysdba.QRTZ_JOB_DETAILS

DELETE FROM sysdba.QRTZ_LOCKS

DELETE FROM sysdba.QRTZ_PAUSED_TRIGGER_GRPS

DELETE FROM sysdba.QRTZ_SCHEDULER_STATE

DELETE FROM sysdba.QRTZ_SIMPLE_TRIGGERS

DELETE FROM sysdba.QRTZ_SIMPROP_TRIGGERS

DELETE FROM sysdba.QRTZ_TRIGGERS

• Start Cache Service
• Start Job Service