Assume that two critical jobs are scheduled to run every week at the following times.
Job 1 runs from 07:00 to 10:00 on Tuesday and Wednesday.
Job 2 runs from 08:00 on Saturday to 13:00 on Sunday.
The following table uses “1” to indicate when job 1 runs and “2” to indicate when job 2 runs:
Day |
Time |
00:00 |
01:00 |
02:00 |
03:00 |
04:00 |
05:00 |
06:00 |
07:00 |
08:00 |
09:00 |
10:00 |
11:00 |
12:00 |
13:00 |
14:00 |
15:00 |
16:00 |
17:00 |
18:00 |
19:00 |
20:00 |
21:00 |
22:00 |
23:00 |
00:00 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Mon |
||||||||||||||||||||||||||
Tues |
1 |
1 |
1 |
1 |
||||||||||||||||||||||
Wed |
1 |
1 |
1 |
1 |
||||||||||||||||||||||
Thurs |
||||||||||||||||||||||||||
Fri |
||||||||||||||||||||||||||
Sat |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
|||||||||
Sun |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
Job 1 can be covered by a single time range, tu_wed_7_10:
sp_add_time_range tu_wed_7_10, tuesday, wednesday, "7:00", "10:00"
Job 2, however, requires two separate time ranges, for Saturday and Sunday:
sp_add_time_range saturday_night, saturday, saturday, "08:00", "23:59" sp_add_time_range sunday_morning, sunday, sunday, "00:00", "13:00"
