Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!j33g2000cwa.googlegroups.com!not-for-mail
From: "aman.oracle.dba" <aman.oracle.dba@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: (month is february and year is leap) job scheduling DBMS_JOB with oracle 9I
Date: 5 May 2006 03:19:02 -0700
Organization: http://groups.google.com
Lines: 9
Message-ID: <1146824342.179516.192070@j33g2000cwa.googlegroups.com>
References: <1146823816.461728.285380@j73g2000cwa.googlegroups.com>
NNTP-Posting-Host: 221.134.238.214
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1146824347 25854 127.0.0.1 (5 May 2006 10:19:07 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 5 May 2006 10:19:07 +0000 (UTC)
In-Reply-To: <1146823816.461728.285380@j73g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: j33g2000cwa.googlegroups.com; posting-host=221.134.238.214;
   posting-account=yp-b7w0AAAAeseIlzSB0lLDs-NuzgUnN
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:266947

Hi,
Use Last_day function to find Last day of current month.
Then make a small procedure to transfer data to one table to another
table.
Then use that in dbms_job

Exa.
select last_day(sysdate) from dual;