下面为创建定时器job的基本属性的配置sql
begin
sys.dbms_scheduler.create_job(
job_name => 'test',
job_type => 'STORED_PROCEDURE',
job_aciotn => 'pro_test',
repeat_interval => 'Freq=Daily;Interval=1'
);
end;
sys.dbms_scheduler.create_job(
job_name => 'test',
job_type => 'STORED_PROCEDURE',
job_aciotn => 'pro_test',
repeat_interval => 'Freq=Daily;Interval=1'
);
end;