RE: 10g Scheduler

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Tue, 5 Sep 2006 10:46:08 -0700 (PDT)
Message-ID: <20060905174608.27674.qmail@web51313.mail.yahoo.com>

Mark

Yes I want it to run three time a day on Week days and not on Weekend

Sanjay

"Bobak, Mark" <Mark.Bobak_at_il.proquest.com> wrote:

So, what you really want is a job that runs 3 times a day, at 9:00am, 3:00pm, and 9:00pm?

--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialization is for insects." --Robert A. Heinlein

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra Sent: Tuesday, September 05, 2006 1:07 PM To: smishra_97_at_yahoo.com; oracle-l_at_freelists.org Subject: Re: 10g Scheduler

Can I create two windows as one already defined and second for 6 hourly and then Window group for these two windows and assign it to the Job

TIA
Sanjay

Sanjay Mishra <smishra_97_at_yahoo.com> wrote:

I want to run one Stored procedure every 6 hourly on Week days between 9am EST to 10pm EST. Can somebody give me some idea as how it will work with 10g Sceduler. Here is what is been done

I had created a window for week days from 9 -10pm.
Now I need to know as how can I use this window to run the job on 6 hour

TIA
Sanjay

Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.

Want to be your own boss? Learn how on Yahoo! Small Business.

Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail.

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

Received on Tue Sep 05 2006 - 12:46:08 CDT