oracle dbms_scheduler to run multiple procedures in parallel
I've trying to figure out oracle's DBMS_SCHEDULER (Oracle 11g) and need
help setting up the following:
I have a procedure that calls a list of other procedures like this:
CREATE OR REPLACE
PROCEDURE RUN_JOBS AS
BEGIN
MYUSER.MYPROCEDURE1();
MYUSER.MYPROCEDURE2();
MYUSER.MYPROCEDURE3();
MYUSER.MYPROCEDURE4();
MYUSER.MYPROCEDURE5();
END;
/
I would like to use DBMS_SCHEDULER to run MYPROCEDURE3(), MYPROCEDURE4(),
MYPROCEDURE5() in parallel after the completion of MYPROCEDURE2().
Can someone show me an example on how to set this up?
No comments:
Post a Comment