Re: Job scheduling in 11g

Haven't tried this myself but scheduler chains might be just what you need here. Have a look at the Admin Guide, it should provide you with more information. Also check MOS for known problems.

Hope this helps,

Martin Bach

Oracle Certified Master 10g
http://martincarstenbach.wordpress.com
http://www.linkedin.com/in/martincarstenbach

• Reply message ----- From: "Ravi Madabhushanam" <ravi.madabhushanam_at_gmail.com> Date: Thu, Jun 17, 2010 05:51 Subject: Job scheduling in 11g To: "oracle-l_at_freelists.org" <Oracle-L_at_freelists.org>

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:10:56 CDT