Issue when calling DBMS_SCHEDULER.RUN_JOB in the same loop with use_current_session set to False
Hi All,
Before opening an SR, I thought I would ask in this community.
I'm trying to call the DBMS_SCHEDULER.RUN_JOB procedure in a loop to submit the same job as many times as the loop total increments.
The idea is to launch several concurrent instances of the job.
Since the RUN_JOB procedure can be executed in an asynchronous way through its use_current_session parameter, I thought it would work.
The problem is that it doesn't seem to run another instance if one is already running. Now, according to the documentation about the RUN_JOB procedure: