RE: 10g Scheduler
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 5 Sep 2006 10:46:08 -0700 (PDT)
Mark
Yes I want it to run three time a day on Week days and not on Weekend
Sanjay
"Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sanjay Mishra
Sent: Tuesday, September 05, 2006 1:07 PM
To: smishra_97@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> wrote:
Hi
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.
Other related posts:
