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)

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

"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

Sanjay Mishra <smishra_97@xxxxxxxxx> 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 
  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: