dbms_job.next_date
Hi,
on 11.2.0.4 on Win 2008.
I try to change next date of a job to be executed in next 10 minutes. But it does not change as I wish :
SQL> select job,interval ,to_char( next_date, 'dd/mm/yy hh24:mm:ss') from dba_jobs;
JOB INTERVAL TO_CHAR(NEXT_DATE
---------- -------------------- -----------------
3 SYSDATE + 1 02/12/14 16:12:21
SQL> exec dbms_job.next_date(3, trunc(sysdate) + 1+10/14400);
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> select job,interval ,to_char( next_date, 'dd/mm/yy hh24:mm:ss') from dba_jobs;
JOB INTERVAL TO_CHAR(NEXT_DATE
---------- -------------------- -----------------
3 SYSDATE + 1 02/12/14 00:12:00
I also ran this :