这个SCHEDULER 每10分钟运行一次，但遇上晚上22点，早上1点到6点间停止运行。
[php]
begin
dbms_scheduler.create_schedule
(schedule_name => 'SCHEDULE_HOURLY_STOP_22_1_TO_6',
start_date=> SYSTIMESTAMP,
end_date
=> NULL,
repeat_interval => 'FREQ=MINUTELY;INTERVAL=10;BYHOUR=0,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,23');
end;
/
[/php]
现我发现把6-21之间的小时时间逐个罗列出来很不雅观。
问：有没有简单的写法，比如：6-21代表这个时间段？
[php]
next_run_date: 1999-01-02 20:00:00
next_run_date: 1999-01-02 20:10:00
next_run_date: 1999-01-02 20:20:00
next_run_date: 1999-01-02 20:30:00
next_run_date: 1999-01-02 20:40:00
next_run_date: 1999-01-02 20:50:00
next_run_date: 1999-01-02 21:00:00
next_run_date: 1999-01-02 21:10:00
next_run_date: 1999-01-02 21:20:00
next_run_date: 1999-01-02 21:30:00
next_run_date: 1999-01-02 21:40:00
next_run_date: 1999-01-02 21:50:00
next_run_date: 1999-01-02 23:00:00
next_run_date: 1999-01-02 23:10:00
next_run_date: 1999-01-02 23:20:00
next_run_date: 1999-01-02 23:30:00
next_run_date: 1999-01-02 23:40:00
next_run_date: 1999-01-02 23:50:00
next_run_date: 1999-01-03 00:00:00
next_run_date: 1999-01-03 00:10:00
next_run_date: 1999-01-03 00:20:00
next_run_date: 1999-01-03 00:30:00
next_run_date: 1999-01-03 00:40:00
next_run_date: 1999-01-03 00:50:00
next_run_date: 1999-01-03 06:00:00
next_run_date: 1999-01-03 06:10:00
next_run_date: 1999-01-03 06:20:00
next_run_date: 1999-01-03 06:30:00
next_run_date: 1999-01-03 06:40:00
next_run_date: 1999-01-03 06:50:00
next_run_date: 1999-01-03 07:00:00
next_run_date: 1999-01-03 07:10:00
next_run_date: 1999-01-03 07:20:00
next_run_date: 1999-01-03 07:30:00
[/php] |
