database

Oracle Jobs

view jobs
select *
from user_scheduler_jobs

create job
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'YOUR_JOB_NAME',
job_type => 'stored_procedure',
job_action => 'testproc',
start_date => TRUNC(SYSDATE),
repeat_interval => 'freq=DAILY;byhour=5',
-- repeat_interval => 'freq=hourly;byminute=5',
-- repeat_interval => 'freq=DAILY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=7,15',
enabled => TRUE
);
END;

delete job
exec dbms_scheduler.drop_job('YOUR_JOB_NAME')