When an Async process is started, it creates a record in ACT_RU_JOB table and tries to run it immediately.
lock_exp_time_ will be null during this. If it fails to execute, it resets the lock_exp_time and acquires job to be run later. Is this understanding correct?
Is there a way to find out how many async jobs are running at any point?
select count() from act_ru_job where lock_exp_time_ is null*
Above query includes the ones which are acquired, but not necessarily started to run. Is there a way to get a count of this?