求Oracle的定时任务时间段内运行JOB写法
Oracle的JOB在某时间段重复运行,如想设计成只在每天下午17点到22点运行,期间每隔5分钟运行一次如何写?
这是普通写法
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => '"SSCS"."CSCS001"',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN CJK_YHQGZCR(); END;',
number_of_arguments => 0,
start_date => TO_TIMESTAMP_TZ('2020-05-13 17:17:26.000000000 ASIA/SHANGHAI','YYYY-MM-DD HH24:MI:SS.FF TZR'),
repeat_interval => 'FREQ=MINUTELY;INTERVAL=5',
end_date => NULL,
enabled => FALSE,
auto_drop => FALSE,
comments => '测试测试');
DBMS_SCHEDULER.SET_ATTRIBUTE(
name => '"SSCS"."CSCS001"',
attribute => 'logging_level', value => DBMS_SCHEDULER.LOGGING_OFF);
DBMS_SCHEDULER.enable(
name => '"SSCS"."CSCS001"');
END;