Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DBMS job for last day of the month
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
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