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;