DBMS_SCHEDULER. How do I set frequency to run every 30 minutes
Hi,
I need this job to run every 30 minutes, lets say on 15 minutes and 45 minutes past the hour. What are the necessray changes. I have looked through the docs and have been getting errors when I try and change the line repeat_interval.
begin
dbms_scheduler.create_schedule(
schedule_name =>'HOTLIST_GENERATION',
start_date =>to_date('01-MAR-2007 02:30','DD-MON-YYYY HH24:MI'),
repeat_interval =>'FREQ=Hourly',
end_date =>NULL,
comments =>'Schedule for Hotlist generation');
end;