Search notes:
Oracle: DBMS_SCHEDULER - CREATE_SCHEDULE
dbms_scheduler.create_schedule
creates a
schedule.
After creating, the object is granted access to PUBLIC
, so everyone can use it.
dbms_scheduler.create_schedule
only has input parameters. schedule_name
and repeat_interval
are required, the rest is optional.
begin
dbms_scheduler.create_schedule (
schedule_name => 'xyz' , -- varchar2
start_date => systimestamp , -- timestamp with time zone
repeat_interval => 'freq=daily;interval=1' , -- varchar2
end_date => systimestamp + interval '1' year, -- timestamp with time zone
comments => '…' -- varchar2
);
end;
/