Re: Job scheduling in 11g

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 17 Jun 2010 10:38:11 +0300
Message-id: <4C19D0E3.5020606_at_inter.net.il>

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 -- 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
>
>

--
http://www.freelists.org/webpage/oracle-l

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