Re: complex dbms jobs code

From: Philip Chee <philip_at_aleytys.pc.my>
Date: Fri, 03 May 2002 21:29:08 GMT
Message-ID: <1020461348.6066snx@aleytys.pc.my>

In article <3cd11271.1077108_at_news.mindspring.com> willjamu_at_mindspring.com writes:

>Oracle 8.1.7.3 on Solaris. I have the below. I need to run a job
>Monday through Thursday . It needs to run every 30 minutes at 00
>and 30 minutes after each hour. The below only schedule for 12:30
>each day. Any help on improving the interval to get this to work
>would be cool!

Hi!

I would not schedule anything at all at :00 or :10 or whatever past the hour. Instead I usually use some odd minute such as 17 or 34 minutes; and for different jobs I use a different offset. This generally evens out the load on the system and avoids a whole bunch of scheduled stuff starting at :00 or :30

Philip

---=====================================================================---

 Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA   e-mail: philip_at_aleytys.pc.my Voice:+60.5.291.1011 Fax:+60.5.291.9932    Guard us from the she-wolf and the wolf, and guard us from the thief,

                  oh Night, and so be good for us to pass.

-- 
 þ 20415.55 þ Never take a beer to a job interview.

Received on Fri May 03 2002 - 16:29:08 CDT