DBMS job for last day of the month

From: rb <rich.bevan_at_bt.com>
Date: Mon, 30 Dec 2002 10:33:21 +0000
Message-ID: <3E1020F1.4D79BE79@bt.com>

I am trying to submit a dbms job to run on the last day of every month starting at 31 Dec at 18:30 using the following code:

set serveroutput on

      declare
      jobno  number;
      begin
      dbms_job.submit

(jobno,'glossi_audit.entry_job',TO_DATE('31-Dec-2002 18:30:00','DD-MON-YYYY HH24:MI:SS'),LAST_DAY(TRUNC(sysdate)), false);

      commit;
      end;

This fails with
SQL> @rb1.sql
  7 /

      declare
*
ERROR at line 1:

ORA-23319: parameter value "31/dec/2002" is not appropriate
ORA-06512: at "SYS.DBMS_JOB", line 57
ORA-06512: at "SYS.DBMS_JOB", line 134
ORA-06512: at line 4

Which I narrowed down to the value of the 'interval' parameter. I tried changing the NLS_DATE_FORMAT environment but it still fails. Can anyone tell me the what I can do to make it work ?

I am running Oracle 9.2.0.2 on Sun Sparc Solaris 2.6

Thanks

Rich Received on Mon Dec 30 2002 - 04:33:21 CST