Two things are wrong:
a. the what parameter must end with a ";"
so make it 'glossy_audit.entry_job;'
b. the interval parameter must be a varchar2 and must therefore be enclosed
in single quotes and make it 'LAST_DAY(TRUNC(sysdate))+18.5/24' so it will
return the proper day and time.
I think that must do it, without testing it myself.
rb <rich.bevan_at_bt.com> schreef in berichtnieuws 3E1020F1.4D79BE79_at_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 - 06:28:02 CST
