Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Execution interval is incorrect while using DBMS_JOB.SUBMIT
Hi,
I've created a job using the following code:
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'TEST_ONLY.TEST_JOB;'
,next_date => to_date('17/08/2004 17:33:00','dd/mm/yyyy
hh24:mi:ss')
,interval => 'TRUNC(SYSDATE+5/1440,''MI'')'
,no_parse => TRUE
);
thanks,
Maoz
Received on Tue Aug 17 2004 - 10:47:17 CDT