begin
dbms_scheduler.create_job(job_name => 'scan_table',
job_type => 'STORED_PROCEDURE',
job_action => 'sp_scan_table', --自定义的扫描表存储过程
start_date => to_timestamp('20150827 00:00:00', 'yyyymmdd hh24:mi:ss'),
repeat_interval => 'freq=minutely;interval=10;byhour=17,18,19,20,21,22,23');
end;
/
begin
dbms_scheduler.enable(name => 'scan_table');
end;
/
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024