更新时间:2021-12-13 07:56:01
使用以下间隔定义:
'freq=daily;byhour=8,10,12,14,16;byminute=0'
因此创建作业的完整代码如下:
So the full code to create the job would be something like:
DBMS_SCHEDULER.create_job(
job_name => 'the_job',
job_type => 'STORED_PROCEDURE',
job_action => 'YOUR_PROCEDURE',
repeat_interval => 'freq=daily;byhour=8,10,12,14,16;byminute=0',
enabled => TRUE);