Alert.DelayBetweenResponses Property

Gets or sets the delay between responses in seconds.

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property DelayBetweenResponses As Integer 
    Get 
    Set
'Usage
Dim instance As Alert 
Dim value As Integer 

value = instance.DelayBetweenResponses

instance.DelayBetweenResponses = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int DelayBetweenResponses { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int DelayBetweenResponses {
    int get ();
    void set (int value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member DelayBetweenResponses : int with get, set
function get DelayBetweenResponses () : int 
function set DelayBetweenResponses (value : int)

Property Value

Type: System.Int32
An Int32 value that specifies the number of seconds to delay between each response sent to an alert.

Remarks

Some events can occur many times in a short time and it would not be appropriate to send out many duplicate e-mail messages or pager notifications. In these circumstances you should set the DelayBetweenResponses property to delay the response to an alert.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

Alert Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_add_alert (Transact-SQL)