Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 10g Scheduler

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:

    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    

  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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US