Execute DBMS_JOBs inside a stored procedure
682415May 18 2012 — edited May 19 2012CREATE OR REPLACE PROCEDURE repl.RunAllJobs
IS
BEGIN
DECLARE
a job%TYPE;
BEGIN
DBMS_JOB.submit (a, 'repl.ExecuteSP1);');
DBMS_JOB.submit (a, ' repl.ExecuteSP2;');
DBMS_JOB.submit (a, 'repl.ExecuteSP3);');
DBMS_JOB.submit (a, ' repl.ExecuteSP4;');
END;
END RunAllJobs;
/
The problem is that the SP returns ( meaning shows completed ) after kicking off the jobs.
I want the SP to return ( showing completed ) only after all the jobs are completed successfully, else return error .