HasNotification Property
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The HasNotification property returns the number of SQL Server Agent operators assigned to receive notification for an alert.
Syntaxe
object.HasNotification
Parts
- object
An expression that evaluates to an object in the Applies To list
Data Type
Long
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetHasNotification(LPLONG pRetVal);
Notes
SQL Server Agent attempts to notify one or more operators when an alert is raised. A notification is sent based on both assignment and the operator availability. The days and hours that a SQL Server Agent operator is available are set for each operator. The HasNotification property reports the total number of operators assigned to receive a notification, not the number of operators who actually receive a notification for any particular occurrence of the event raising the alert.