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;