I want to schedule a job to run on 24th on each month (Jan 24,Feb 24,Mar
24,...).But I noticed that by setting Interval to 'sysdate+30',the 'next run
date' is corrent until February 24, after that the job will run on March 25.
(Assuming the first submitted job is on Jan 24).

any idea?
thanks.

You should set Interval to something like 'add_months(sysdate, 1)'. Also,
you may notice the time creeping up each time you run, as the Interval
expression may not get evaluated _precisely_ when you expect it to. So (for
example) if you want to run at 1 AM on the 24th of each month, then you
could do something like 'truncate(add_months(sysdate, 1)) + 1/24'. Truncate
will, by default, truncate a date to midnight, and adding 1/24th of a day
back in gets you to 1 AM. Hopefully this is enough to get you going.

--
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

"col" <colx (AT) hotmail (DOT) com> wrote