Re: Job scheduling in 11g
- From: Ravi Madabhushanam <ravi.madabhushanam@xxxxxxxxx>
- To: Yechiel Adar <adar666@xxxxxxxxxxxx>, Martin Bach <development@xxxxxxxxxxxxxxxxx>
- Date: Thu, 17 Jun 2010 15:29:58 +0530
Thank you Martin and Adar.
Both these options are promising.
I'm more inclined towards database job chains as it will help me explore
other features of database. Ofcourse batch job is always easy. Let me try
these options and get back to you.
Thanks a lot for your inputs.
Regards,
~Ravi.M
On Thu, Jun 17, 2010 at 1:08 PM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote:
> 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
>>
>>
>>
Other related posts:
