NEO
NEO

Reputation: 213

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?

Upvotes: 2

Views: 1745

Answers (1)

DCookie
DCookie

Reputation: 43533

Give the jobs you create random names.

Upvotes: 4

Related Questions