DelayBetweenResponses Property

SQL-DMO

SQL-DMO

DelayBetweenResponses Property

The DelayBetweenResponses property represents the number of seconds SQLServerAgent waits before it generates another response for an alert.

Applies To
Alert Object
Syntax

object.DelayBetweenResponses [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

Long integer that specifies a number of seconds to wait

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDelayBetweenResponses(LPLONG pRetVal);

HRESULT SetDelayBetweenResponses(long NewValue);

Remarks

SQLServerAgent sends e-mail or a network pop-up message to an operator, pages an operator, or logs a message in response to a raised alert. An alert can be raised many times in a short period of time. By default, each time the alert is raised, a response is made. Using the DelayBetweenResponses property, the alert can be tailored so that no matter how many times it is raised in a period of time, only a single response is generated.