Below is the code I have run to schedule the job in oracle using scheduler in oracle. I want to run the procedure every 12 hours. But the job does not run automatically , I need to run it manually. Any help is really appreciated.
-- Job defined entirely by the CREATE JOB procedure.
job_name => 'Load_OMR_data',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN P_LOAD_INVENTORY_DATA( ''' || 'today' || ''') END;',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=HOURLY;Interval=12',
end_date => NULL,
enabled => TRUE,
comments => 'Job to load inventory data for host database instance');