oracle job如何实现每天执行次?
发布网友
发布时间：2022-04-07 18:07
共1个回答
热心网友
时间：2022-04-07 19:36
dbms_scheler.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_scheler.enable(name => 'scan_table');
end;
/
