oracle create_job example
BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name => '"MYSCHEMA"."JOB_NAME"',
job_type => 'STORED_PROCEDURE',
job_action => 'MYSCHEMA.PROCEDURE',
number_of_arguments => 0,
start_date => to_timestamp_tz(
'2021-04-08 14:19:32.000000000 EUROPE/PARIS',
'YYYY-MM-DD HH24:MI:SS.FF TZR'),
repeat_interval =>
'FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI;BYHOUR=12;BYMINUTE=30;BYSECOND=0',
end_date => NULL,
enabled => FALSE,
auto_drop => FALSE,
comments => 'Job description');
DBMS_SCHEDULER.enable(
name => '"MYSCHEMA"."JOB_NAME"');
END;