PagerDays Property
The PagerDays property specifies the days of the week on which Microsoft® SQL Server™ 2000 Agent attempts to notify the referenced operator by page.
Applies To
| Operator Object |
Syntax
object.PagerDays [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Bit-packed long integer value that specifies days of the week as described in Settings
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetPagerDays(SQLDMO_WEEKDAY_TYPE* pRetVal);
HRESULT SetPagerDays(SQLDMO_WEEKDAY_TYPE NewValue);
Settings
| Constant | Value | Description |
|---|---|---|
| SQLDMOWeek_EveryDay | 127 | Operator will be paged on all days. |
| SQLDMOWeek_Friday | 32 | Operator will be paged on Friday. |
| SQLDMOWeek_Monday | 2 | Operator will be paged on Monday. |
| SQLDMOWeek_Saturday | 64 | Operator will be paged on Saturday. |
| SQLDMOWeek_Sunday | 1 | Operator will be paged on Sunday. |
| SQLDMOWeek_Thursday | 16 | Operator will be paged on Thursday. |
| SQLDMOWeek_Tuesday | 4 | Operator will be paged on Tuesday. |
| SQLDMOWeek_Unknown | 0 | No assignment has been made for the referenced operator. |
| SQLDMOWeek_Wednesday | 8 | Operator will be paged on Wednesday. |
| 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. |
Remarks
Combine individual values using an OR logical operator to assign page notification to more than a single day.
Configure an operator for pager notification using the PagerAddress property. Configure operator availability for pager notification using the page start and stop time properties.
See Also
SaturdayPagerStartTime Property