Re: DBMS_JOB interval HOW TO

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Mon, 26 May 2003 06:07:48 +0200
Message-ID: <6n43dv8fobj8o12tsjcpui5f3o1c3r2emo@4ax.com>

On Mon, 26 May 2003 01:19:35 +0200, "Michal Kowalczyk" <mikeeria_at_interia.pl> wrote:

>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
>

end of this month is just last_day(sysdate). The rest you could probably figure out using the last_day and add_months function.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun May 25 2003 - 23:07:48 CDT