Re: Submit job last day of each month

Oops... Sorry, should be: 'TRUNC(LAST_DAY(SYSDATE))' Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 1:03 PM > Your job interval should be: > > 'TRUNC(LAST_DAY(SYSDATE) +

Re: Submit job last day of each month

Your job interval should be: 'TRUNC(LAST_DAY(SYSDATE) + 1)' Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 12:25 PM > Hi, > > Does anyone know how I can submit a job using dbms_

Submit job last day of each month

Hi, Does anyone know how I can submit a job using dbms_job the last day of each month. I know there is a last_day function but cannot figure how to use this correctly in dbms_job. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED]