I am using 10.2.0.4.0 version of oracle. i am supposed to migrate all the Oracle jobs(DBMS_JOBS) to SCHEDULER format in my DB.
Below is an example of a job which runs each day at 5 AM. I have coded the start_date value such that, i can execute the script at anypoint of time in the day without hampering the job execution for the day.
i want to know, Whether Create_schedule method can be used in this scenario? How is Create_Scheduler implementation will be better than below implementation?
-- DBMS_SCHEDULER Code
job_type => 'PLSQL_BLOCK',
start_date => CASE
TRUNC(SYSDATE+1) + (5/24)
repeat_interval => 'TRUNC(SYSDATE+1) + (5/24)',
enabled => true, auto_drop=> false,
comments => 'Converted from job 123'