PagerDays Property
未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。
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]
Parts
- object
An expression that evaluates to an object in the Applies To list.
- value
A 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 |
The operator will be paged on all days. |
SQLDMOWeek_Friday |
32 |
The operator will be paged on Friday. |
SQLDMOWeek_Monday |
2 |
The operator will be paged on Monday. |
SQLDMOWeek_Saturday |
64 |
The operator will be paged on Saturday. |
SQLDMOWeek_Sunday |
1 |
The operator will be paged on Sunday. |
SQLDMOWeek_Thursday |
16 |
The operator will be paged on Thursday. |
SQLDMOWeek_Tuesday |
4 |
The operator will be paged on Tuesday. |
SQLDMOWeek_Unknown |
0 |
No assignment has been made for the referenced operator. |
SQLDMOWeek_Wednesday |
8 |
The operator will be paged on Wednesday. |
SQLDMOWeek_WeekDays |
62 |
The operator will be paged on Monday, Tuesday, Wednesday, Thursday, and Friday. |
SQLDMOWeek_WeekEnds |
65 |
The operator will be paged on Saturday and Sunday. |
備註
Combine individual values using an OR logical operator to assign pager 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.
Applies To:
請參閱
參考
PagerAddress Property
SaturdayPagerEndTime Property
SaturdayPagerStartTime Property
SundayPagerEndTime Property
SundayPagerStartTime Property
WeekdayPagerEndTime Property
WeekdayPagerStartTime Property