Compartilhar via

NotificationClass.NotificationBatchSize Property

  • Artigo

Gets or sets the notification batch size. For notifications not sent using digest delivery, the batch size specifies the maximum number of notifications per batch for the notification class. When using digest delivery, the batch size specifies the number of notification batches that are created.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Property NotificationBatchSize As Integer

public int NotificationBatchSize { get; set; }

public:
property int NotificationBatchSize {
    int get ();
    void set (int value);
}

/** @property */
public int get_NotificationBatchSize ()

/** @property */
public void set_NotificationBatchSize (int value)

public function get NotificationBatchSize () : int

public function set NotificationBatchSize (value : int)

Property Value

An Int32 that specifies the notification batch size for the notification class.

Remarks

NotificationBatchSize must be set to zero or not specified in Standard Edition.

For notifications that are not sent using digest delivery, the NotificationBatchSize value specifies the maximum number of notifications that can be included in a notification batch from a single rule firing. If the number of notifications generated from a single rule firing exceeds the NotificationBatchSize value, Notification Services creates multiple notification batches. Notifications within a notification batch can be considered for multicast delivery.

For digest delivery, NotificationBatchSize specifies the number of notification batches permitted from a single invocation of the generator, not the size of each batch. This is intended for use with large numbers of notifications. If the number of notifications generated is small, the number of notification batches might be different than specified.

Example

The following examples show how to set the notification batch size to 500:

flightNotifications.NotificationBatchSize = 500;

flightNotifications.NotificationBatchSize = 500

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

NotificationClass Class
NotificationClass Members
Microsoft.SqlServer.Management.Nmo Namespace

Other Resources

Defining Notification Classes
NotificationBatchSize Element (ADF)
Specifying the Notification Batch Size