次の方法で共有


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:

Operator Object

参照

関連項目

PagerAddress Property
SaturdayPagerEndTime Property
SaturdayPagerStartTime Property
SundayPagerEndTime Property
SundayPagerStartTime Property
WeekdayPagerEndTime Property
WeekdayPagerStartTime Property

ヘルプおよび情報

SQL Server 2005 の参考資料の入手