Oracle - Change next Job execution date

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:



Popular posts from this blog

Oracle - duplicate fields in RECORD,TABLE or argument list are not permitted

Oracle - ORA-29282: invalid file ID, ORA-06512: at "SYS.UTL_FILE"