Database Administration (MOSC)

MOSC Banner

Issue when calling DBMS_SCHEDULER.RUN_JOB in the same loop with use_current_session set to False

edited Apr 29, 2014 4:43AM in Database Administration (MOSC) 6 commentsAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center