Good morning all,
Sorry to ask something that might be asked before but I cannot find an existing post related to what I'm looking for...
I actually have 4 procedures for which I've created a specific Job. (so 4 procedures -> 4 jobs).
Each of them runs for 1hr.
I've created a combined procedure as below and expected to have this done in 1hr, unfortunately it runs for 4hrs.
(when executing them manually at the same time, all complete in 1hr, so I expect the same performance)
CREATE OR REPLACE EDITIONABLE PROCEDURE "BCTCUSTOM"."SP008_01_DSH_COMBINED_SP" AS
BEGIN
dbms_scheduler.run_job('JOB008_DSH_PROCEDURE1);
COMMIT;
dbms_scheduler.run_job('JOB008_DSH_PROCEDURE2);
COMMIT;
dbms_scheduler.run_job('JOB008_DSH_PROCEDURE3);
COMMIT;
dbms_scheduler.run_job('JOB008_DSH_PROCEDURE4);
COMMIT;
END SP008_01_DSH_COMBINED_SP;
What can I do to execute them all in the same time?
(except setting up the same scheduler for all jobs)
Thanks a lot,
Ben