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: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 5 Sep 2006 13:46:02 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF27096A3931@AABO-EXCHANGE02.bos.il.pqe>


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 - 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 <http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com> to the US (and 30+ countries) for 2/min or less.
________________________________
Want to be your own boss? Learn how on Yahoo! Small Business. <http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index> -- http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 05 2006 - 12:46:02 CDT

Original text of this message

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