DelayBetweenResponses 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 DelayBetweenResponses property represents the number of seconds SQL Server Agent waits before it generates another response for an alert.
Syntax
object
.DelayBetweenResponses [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
Along 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
SQL Server Agent 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.