Oracle-L: RE: Unix - scheduling

From: Richard Huntley <rhuntley_at_mindleaders.com>
Date: Tue, 02 Jul 2002 08:53:35 -0800
Message-ID: <F001.0048E060.20020702085335@fatcity.com>

Ummmm...think they slipped something into my Mountain Dew while I wasn't looking so that they could
log into production directly via SQL*Plus and make some manual changes...I must have still been
regaining my senses when I sent this...sorry :)

-----Original Message-----
Sent: Tuesday, July 02, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L

Is a strick 14 day rule absolutely necessary, if not...a much more hassle free way would be to
simply schedule the cronjob to run on the 1st and 15th of each month, i.e.

# Min Hr Day Mon WkDay Command
0 0 1,15 * * <script>

-----Original Message-----
<mailto:lembark_at_wrkhors.com> ]
Sent: Tuesday, July 02, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L

Nils Höglund <nils_at_naqua.se> on 07/02/02 03:28:20 -0800

> 0 */4 * * * your_command

$ man 5 cronttab;

The time and date fields are:

              field          allowed values 
              -----          -------------- 
              minute         0-59 
              hour           0-23 
              day of month   1-31 
              month          1-12 (or names, see below) 
              day of week    0-7 (0 or 7 is Sun, or use names) 

       A field may be an asterisk (*), which always stands for

``first-last''.

Ranges of numbers are allowed. Ranges are two numbers separated with a
hyphen. The specified range

is inclusive. For example, 8-11 for an ``hours'' entry specifies execution at hours 8, 9, 10 and 11.

Lists are allowed. A list is a set of numbers (or ranges)

separated by commas. Examples:

``1,2,5,9'', ``0-4,8-12''.
:

Question: how does "0 */4 * * *" cause something to run every 4 weeks? Unless your version has a different field order. It might work to try "* */628 * * *" but I'm not sure that cron allows n>24 for the hourly divisor.

The combination of date and weekday can approximate the 4-week cycle.

Steven Lembark                              2930 W. Palmer 
Workhorse Computing                      Chicago, IL 60647 
                                           +1 800 762 1582

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com>
--

Author:
INET: lembark_at_wrkhors.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California        -- Public Internet access / Mailing Lists 
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Richard Huntley
INET: rhuntley_at_mindleaders.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------