What about the 1st of the next month minus a day? Should reliably give you
the last day of the month.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Michal Kowalczyk" <mikeeria_at_interia.pl> wrote in message
news:barihp$3qg$1_at_atlantis.news.tpi.pl...
> Hye
>
> How to set DBMS_JOB to run a procedure at each last day of a month ?
>
> DBMS_JOB(:jobnumber, 'Procedure_name', "end of this month", "end of next
> month")
>
>
> TIA
>
> Michal
>
>
Received on Sun May 25 2003 - 20:20:46 CDT
