The PagerDays property specifies the days of the week on which SQL Server Agent attempts to notify the referenced operator by page.
object.PagerDays [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Bit-packed long integer value specifying days of the week as described in Settings |
| Constant | Value | Description |
|---|---|---|
| SQLDMOWeek_EveryDay | 127 | Operator will be paged on all days |
| SQLDMOWeek_Sunday | 1 | Operator will be paged on Sunday |
| SQLDMOWeek_Monday | 2 | Operator will be paged on Monday |
| SQLDMOWeek_Tuesday | 4 | Operator will be paged on Tuesday |
| SQLDMOWeek_Wednesday | 8 | Operator will be paged on Wednesday |
| SQLDMOWeek_Thursday | 16 | Operator will be paged on Thursday |
| SQLDMOWeek_Friday | 32 | Operator will be paged on Friday |
| SQLDMOWeek_Saturday | 64 | Operator will be paged on Saturday |
| SQLDMOWeek_WeekDays | 62 | Operator will be paged on Monday, Tuesday, Wednesday, Thursday, and Friday |
| SQLDMOWeek_WeekEnds | 65 | Operator will be paged on Saturday and Sunday |
| SQLDMOWeek_Unknown | 0 | No assignment has been made for the referenced operator |
Combine individual values by using an Or to assign page notification to more than a single day.
Configure an operator for pager notification by using the PagerAddress property. Configure operator availability for pager notification using the page start and stop time properties.
Long, enumerated
Read/write
HRESULT GetPagerDays(SQLDMO_WEEKDAY_TYPE* pRetVal);
HRESULT SetPagerDays(SQLDMO_WEEKDAY_TYPE NewValue);