Determe the Time Ranges You Need

Use a chart to determine the time ranges to create for each server. Monitor server usage throughout the week; then indicate the periods when your server is especially busy or is performing crucial tasks that should not be interrupted.

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

Wed

Thur

Fri

Sat

Sun

Use sp_add_time_range to:

See sp_add_time_range in the Reference Manual: Procedures.

A Time Range Example

This example assumes that two critical jobs run every week.

  • 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"