Track count of running async jobs


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?


No, this is not correct. A job that is being executed immediately will be inserted with a lock owner and lock time.

See my response to Get count of number of running async jobs - #2 by joram