• Article

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.

Applies To:

Alert Object