Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

PagerDays Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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]
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.

Long, enumerated

Read/write

HRESULT GetPagerDays(SQLDMO_WEEKDAY_TYPE* pRetVal);
HRESULT SetPagerDays(SQLDMO_WEEKDAY_TYPE NewValue);

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.