다음을 통해 공유


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 지원 받기