I finally got around to trying this. Apparently oracle doesn't like
the interval...
SQL> variable v_JobNo number;
SQL> exec dbms_job.submit(:v_JobNo, 'test;', TRUNC(SYSDATE),
'TRUNC(SYSDATE)+(1/8640)');
BEGIN dbms_job.submit(:v_JobNo, 'test;', TRUNC(SYSDATE),
'TRUNC(SYSDATE)+(1/8640)'); END;
*
ERROR at line 1:
ORA-23420: interval must evaluate to a time in the future
ORA-06512: at "SYS.DBMS_JOB", line 57
ORA-06512: at "SYS.DBMS_JOB", line 134
ORA-06512: at line 1
Received on Thu Feb 16 2006 - 10:06:38 CST
