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:

Name the time range
Specify the days of the week to begin and end the time range
Specify the times of the day to begin and end the time range

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