Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> (month is february and year is leap) job scheduling DBMS_JOB with oracle 9I

(month is february and year is leap) job scheduling DBMS_JOB with oracle 9I

From: sanjeev <sanjeev_atvankar_at_yahoo.co.in>
Date: 5 May 2006 03:10:16 -0700
Message-ID: <1146823816.461728.285380@j73g2000cwa.googlegroups.com>


hello,

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. but what is the logic IF month is february and year is leap.

could anyone suggest..........

send me mail on
sanjeev_atvankar_at_yahoo.co.in Received on Fri May 05 2006 - 05:10:16 CDT

Original text of this message

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