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: CRon help

RE: CRon help

From: Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk>
Date: Thu, 23 Jun 2005 11:24:16 +0100
Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F63030F0C0F@UKWMXM04>


Charlotte Hammond suggested this to a similar question recently

Something like this (1am on 2nd Saturday):

00 01 8,9,10,11,12,13,14 * 6 /app/my_saturday_job.sh

Takes advantage of the fact that the second Saturday can only possibly fall in the range of dates 8th to the 14th of the month (and no other Saturday can fall on those days!)

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Sent: 22 June 2005 18:34
To: oracle-l_at_freelists.org
Subject: CRon help

Not exactly Oracle specific, but I know many of you know the answer to this I imagine...
How can I schedule a cron job to submit a job on the thurd Sunday of every
month.

I took at a stab at it thusly:
00 8 15-22 * 0

But now I realize that is an OR condition and so jobs every sunday and on
the 15-22 are getting submitted instead of just every sunday that falls on
the 15-22.

Any help/inisight appreciated!!
--

..
David

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 23 2005 - 06:29:50 CDT

Original text of this message

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