SQL*Plus (MOSC)

MOSC Banner

dbms_job.next_date

edited Dec 2, 2014 3:14AM in SQL*Plus (MOSC) 2 commentsAnswered ✓

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 :

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center