Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: crontab question
its been ages since i've setup cron
how about 00 09 1-7 * 0
joe
Lisa_Koivu_at_gelco.com wrote:
>
> Hello -
>
> I'm curious: How would I enter the date for a crontab entry if I want a job to
> run the first Sunday of every month?
>
> Would it be redundant like this:
>
> 0 9 1,2,3,4,5,6,7 * 0
>
> Thanks
> Lisa
> Minneapolis,MN,USA
> *O*verly *C*autious *P*utz
>
> --
> Author:
> INET: Lisa_Koivu_at_gelco.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).
The time and date fields are:
field allowed values ----- -------------- minute 0-59 hour 0-23 day of month 0-31 month 0-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 inclu- sive. 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''.
-- Joe Testa http://www.oracle-dba.com Oracle 8i documentation online http://www.oracle-dba.com/oracle-docsReceived on Mon Jun 12 2000 - 19:45:08 CDT