Re: Job scheduling in 11g

You probably want to look at DBMS_SCHEDULER rather than DBMS_JOBS. 
DBMS_SCHEDULAR is the new job scheduler and It allows the daisy chaining that 
you are looking for and direct execution of external jobs from within the 
database. OEM has an interface into DBMS_SCHEDULER. One word of warning. The 
new job scheduler has a lot more functionality, and is thus a bit more complex. 

Cheers!

RF


 Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE
Author of various books on RMAN, New Features and this shorter signature line.
Blog: http://robertgfreeman.blogspot.com




________________________________
From: Ravi Madabhushanam <ravi.madabhushanam@xxxxxxxxx>
To: Yechiel Adar <adar666@xxxxxxxxxxxx>; Martin Bach 
<development@xxxxxxxxxxxxxxxxx>
Cc: "oracle-l@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
Sent: Thu, June 17, 2010 3:59:58 AM
Subject: Re: Job scheduling in 11g

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: