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: how to schedule a job on second saturday using cron ?

Re: how to schedule a job on second saturday using cron ?

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Mon, 30 May 2005 21:20:56 +0800
Message-ID: <5e30486205053006201582d639@mail.gmail.com>


Use the scheduler in 10g=20

FREQ=3DMONTHLY; BYDAY=3D2SAT easy as that...

:-)

On 5/29/05, Mark Bole <makbo_at_pacbell.net> wrote:
> Hmm, that's odd, it should not work. From the crontab documentation
> (man page):

>=20

> "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."
>=20

--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 30 2005 - 09:25:48 CDT

Original text of this message

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