SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Technical Reference
SQL-DMO Reference
Properties (SQL-DMO)
D (SQL-DMO Properties)
Database Property
DatabaseFileGroups Property
DatabaseFiles Property
DatabaseName Property
DatabaseUserName Property
DataFile Property
DataFilePath Property
DataFileSize Property
DataFileType Property
DataFolder Property
DataSource Property
DataSpaceUsage Property
DataSpaceUsed Property
Datatype Property
DateCreated Property
DateFindOperand Property
DateJobCreated Property
DateJobLastModified Property
DateLastModified Property
Day Property
Days Property
DboLogin Property
DBOUseOnly Property
DBOwner Property
DBReadOnly Property
Default Property (Column, UserDefinedDatatype)
Default Property (FileGroup)
DefaultCursor Property
DefaultDomain Property
DefaultLogin Property
DefaultOwner Property
DefaultPath Property
DelayBetweenResponses Property
DeleteCommand Property
DeleteLevel Property
DenyNTLogin Property
DestDatabase Property
DestinationObjectName Property
DestinationOwnerName Property
DestLogin Property
DestPassword Property
DestServer Property
DestTranslateChar Property
DestUseTrustedConnection Property
DeviceNumber Property
Devices Property
DistributionAgent Property
DistributionCleanupTaskName Property
DistributionDatabase Property
DistributionJobID Property
DistributionServer Property
DistributionWorkingDirectory Property
Distributor Property
DistributorAvailable Property
DistributorInstalled Property
DistributorLocal Property
DropDestObjectsFirst Property
DropLogins Property
DTSPackageLocation Property
DTSPackageName Property
DTSPackagePassword Property
DynamicFilterHostName Property
DynamicFilterLogin Property
DynamicFilters Property
DynamicReconfigure Property
DynamicSnapshotJobId Property
DynamicSnapshotLocation Property
Expand Minimize
This topic has not yet been rated - Rate this topic

DelayBetweenResponses Property

SQL Server 2008

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.

Copy 
object.DelayBetweenResponses [=value]
object

An expression that evaluates to an object in the Applies To list

value

Along integer that specifies a number of seconds to wait

Read/write

Copy 
HRESULT GetDelayBetweenResponses(LPLONG pRetVal);
HRESULT SetDelayBetweenResponses(long NewValue);

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.