A schedular will call the mentioned procedure every mentioned intervel of time. Like below
Procedure created like below
create or replace procedure test_none is
select max(num) into lv_cnt from TEST_DATA;
insert into TEST_DATA values(lv_cnt+1,'ABC');
Schedular created like below
job_name => 'test_scheduler',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN test_none; END;',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=hourly; byminute=1; bysecond=0;',
enabled => TRUE);
It will call the proc every hour first minut. Like if it is compiled at 12 PM. then proc will call at 1,2 ,3...etc
Below are some examplet time intervals.
-->runs for every 3 Minuts
repeat_interval => 'FREQ=MINUTELY;INTERVAL=3',
-->Run every Friday. (All three examples are equivalent.)
-->Run every other Friday.
FREQ=WEEKLY; INTERVAL=2; BYDAY=FRI;
-->Run on the last day of every month.
-->Run on the next to last day of every month.
-->Run on March 10th. (Both examples are equivalent)
FREQ=YEARLY; BYMONTH=MAR; BYMONTHDAY=10;
-->Run every 10 days.
-->Run daily at 4, 5, and 6PM.