You can do that easily in windows. Just from the top of my head. Each job creates file jobx.ok or jobx.error. file: schedule jobs.cmd del *.ok del *.error call job1.cmd if exist job1.error goto :error attach job2.cmd attach job3.cmd attach job4.cmd attach job5.cmd :check if exist *.error goto :error if not exist job2.ok go to :recheck if not exist job3.ok go to :recheck if not exist job4.ok go to :recheck if not exist job5.ok go to :recheck call job6.cmd if exist job6.error goto :error call job7.cmd if exist job7.error goto :error goto :finish :recheck sleep 30 goto :check :error echo batch finished with error. exit 50 :finish exit 0 Adar Yechiel Rechovot, Israel Ravi Madabhushanam wrote:
Hello All,We have a requirement to schedule multiple jobs in Oracle 11g (11.1.0.7) on windows. We have multiple jobs which needs to be executed in a specific order serial and parallel.Below is the sequence of our jobs. Job 1 -- serial Job 2 -- parallel Job 3 -- parallel Job 4 -- parallel Job 5 -- parallel Job 6 -- serial Job 7 -- serialAfter completion of Job1 we need start job 2,3,4 and 5 in parallel. After completion of all jobs 1-5, Job 6 should start. And job 7 should run only after execution of Job6.On linux I would have opted for shell scripting for this. But we are on windows now and I'm not really confident about it. I thought DBMS_Job can be used for this. Could you guys please share your opinion on how best I can approach this requirement. Is DBMS_JOB the right choice ? do we have any better way to do this.Thanks a lot. Regards, Ravi.M
-- //www.freelists.org/webpage/oracle-l