Re: Job scheduling in 11g

From: Yechiel Adar <>
Date: Thu, 17 Jun 2010 10:38:11 +0300
Message-id: <>

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

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
sleep 30
goto :check
echo batch finished with error.
exit 50
exit 0

Adar Yechiel
Rechovot, Israel

Ravi Madabhushanam wrote:
> Hello All,
> We have a requirement to schedule multiple jobs in Oracle 11g
> ( 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 -- serial
> After 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

Received on Thu Jun 17 2010 - 02:38:11 CDT

Original text of this message