Hi All,
Suppose that I have two jobs. I want to run both of them in a particular order in another session. First I want to run JOB_1. After JOB_1 finishes then JOB_2 should be run. Is there any way to run accomplish this?
If I run the following plsql block they run parallel. However, I want JOB_2 to wait JOB_1. After JOB_1 finishes, then JOB_2 start.
begin
DBMS_SCHEDULER.RUN_JOB(JOB_NAME => 'JOB_1', USE_CURRENT_SESSION => FALSE);
DBMS_SCHEDULER.RUN_JOB(JOB_NAME => 'JOB_2', USE_CURRENT_SESSION => FALSE);
end;
Thanks in advance.