A time range example

Assume that two critical jobs are scheduled to run every week at the following times.

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"