Compartir a través de


HasNotification Property

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The HasNotification property returns the number of SQL Server Agent operators assigned to receive notification for an alert.

Sintaxis

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);

Comentarios

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.

Applies To: