Clicky

Oracle - Change next Job execution date

November 23, 2011

List of existing jobs:

select * from dba_jobs;

Get the actual Oracle Job next execution date:

select to_char( next_date, ‘YYYYMMDD:HH24MI’) from dba_jobs where job = 181;

Test the next execution time:

select to_char( trunc(SYSDATE) + ((16*60)+50)/1440 , ‘YYYYMMDD:HH24MI’) from dual;

Execute the job update:

exec DBMS_JOB.next_date ( <JOB_ID>, trunc(SYSDATE) + ((16*60)+50)/1440);

Commit the changes:

Commit;