Re: schedule job every month 12:00 pm

sanjeev wrote:
> I am developing an application in which i need to transfer data from
> one table to another table within same schema in ORACLE 9i.
>
> transfer period = month end (12:00 am)
> i.e. data will be transfer on last date of every month at 12:00 mid
> night
> e.g.
> IF month is janaury then transfer at 31-01-06 (12:00 am)
> month is february then transfer at 28-02-06/29-02-06 (12:00
> am)
> month is march then transfer at 30-01-06 (12:00 am)
> --
> ----
> ----
> and so on.............
> for above problem i am using DBMS_JOB for scheduling.
> my code is as follows
> declare
> v_job number;
> begin
> dbms_job.submit(
> v_job,
> 'consolidate; end;',
> sysdate,
> 'sysdate+2/24'
> );
> end;
> so what is the value of 'INTERVAL:' parameter for above situation so
> that it can handle leap/non leap problem.
>
> could anyone suggest..........
> my email: sanjeev_atvankar_at_yahoo.co.in

.. dbms_job.submit(v_job, '.....',

                             trunc(last_day(sysdate)),
                             'add_months(trunc(last_day(sysdate)),1)'
                            );