The DelayBetweenResponses property represents the number of seconds SQL Server Agent waits before it generates another response for an alert.
object.DelayBetweenResponses [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer specifying a number of seconds to wait |
SQL Server Agent sends e-mail or a network popup 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. 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, only a single response is generated.
Long
Read/write
HRESULT GetDelayBetweenResponses(LPLONG pRetVal);
HRESULT SetDelayBetweenResponses(long NewValue);