We are using Apex automations to run some scheduled processes. We experience frequently that some automations are stuck in “Job Already Running” status in the Apex Automation Execution Log. We suspect that this happens in case the database has been restarted “unexpectedly”. When this happens we cannot find any solution for getting the automations to run again.
The scheduling works - meaning that the automation job fires as expected, but the job immediately exits when the message “Job Already Running”. We understand the normal purpose of this functionality (to allow a job to finish before the next scheduled run), but in the said situation the job is in fact not running. Only APEX thinks it is running.
In some cases we have been able to solve the problem by calling APEX_AUTOMATION.ABORT (not terminate because we are on version 23.2). But that does not solve the problem we face now. Also tried to disable/enable the schedule without any luck. Still hitting “Job Already Running”. Also, when we have the problem the APEX_AUTOMATION.IS_RUNNING is returning false!
Are we the only ones having these problems and what is the best way to come around it?