Hi Joram,
While the engine has locked some jobs for processing, then restarting the servers or because of a crash, thos jobs will never be processed. Typically, the LOCK_EXP_TIME_ has some value, the LOCK_OWNER_ = null, DUEDATE_= null, and RETRIES_ > 0.
If I trigger them manually, that is setting LOCK_EXP_TIME_ = null and DUEDATE_ = CURRENT_TIMESTAMP, they will be picked up and consumed.
Do you have suggestion of how to overcome this issue, other than creating a scanning thread for such jobs and try to unlock them?
Thanks,
Dan