Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: CRon help
Hi John , the same thread had this too : )
"Note: The day of a command's execution can be specified by two fields -- day of month, and day of week. If both fields are restricted (ie, aren't *), the command will be run when _either_ field matches the current time. For example, ``30 4 1,15 * 5'' would cause a command to be run at 4:30 am on the 1st and 15th of each month, plus every Friday."
So the example below would run every Saturday plus 8th-14th of the month, not what you want.
A quick search of Google gives you something better, like this:
0 1 8-14 * * [ "$(date +\%a)" == "Sat" ] && script_with_no_date_logic
Regards,
Prem.
-----Original Message-----
>> From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On >> Behalf Of Hallas, John,
Tech Dev
>> 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!)
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 23 2005 - 06:55:03 CDT
![]() |
![]() |