Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

12 am in dbms schduler job is 00 or 24

ReemaPuriSep 2 2018 — edited Sep 21 2018

i have one question if my understanding is correct  if i fire below query and time is shown below

and i want to run my script  daily at 12 am  in night so is the timing correct

select current_timestamp from dual;

02-SEP-18 17.57.41.897027000 EUROPE/LONDON

begin

dbms_scheduler.create_job (

   job_name           =>  'SYNC_NEW_TO_OLD',

   job_type           =>  'STORED_PROCEDURE',

   job_action         =>  'IN_PKG.ADD_INT',

   start_date         =>  SYSDATE,

   repeat_interval    =>  'FREQ=DAILY ; BYHOUR=00;BYMINUTE=00;',

   enabled            =>  TRUE,

   comments      =>  'Job to run Daily at 12 am ');

END;

This post has been answered by Paulzip on Sep 2 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2018
Added on Sep 2 2018
6 comments
3,334 views