Search code examples
oracle-databaseplsqlschedulerjobs

How run two or more instances of an oracle job in the same time?

I have defined a function that when it is called it will define an oracle job with

dbms_scheduler.create_job

that runs a store_procedure with arguments

my Function
Begin
    job created and executed from here
end;

My problem is that when an instance of my job is executing I can not execute another instance of that job. as I said my jobs executes a store_procedure that have arguments so I want to execute that job with different values of arguments in the same time but I can not. is there any property or way that can help me to do this?

Solution

  • Give the jobs you create random names.