Export (0) Print
Expand All
Expand Minimize

NSEventBatchList (Transact-SQL)

SQL Server 2005

Updated: 5 December 2005

Lists the event batches submitted by an event provider to an event class.


[ schema_name ].NSEventBatchList
    [ @ProviderName = ] 'event_provider_name',
    [ @EventClassName = ] 'event_class_name'

[ @ProviderName = ] 'event_provider_name'

The name of an event provider for the application. event_provider_name is nvarchar(255) and has no default value.

[ @EventClassName = ] 'event_class_name'

The name of an event class for the application. event_class_name is nvarchar(255) and has no default value.

0 (success) or 1 (failure)

The NSQuantumList result set is ordered by QuantumId.

Column name Data type Description

ProviderName

nvarchar(255)

Name of the event provider that submitted the batch of events.

EventBatchId

bigint

Identifier for the event batch.

EventCount

bigint

Number of events in the event batch.

StartCollectionTime

datetime

Date and time that event batch collection started, in Coordinated Universal Time (UTC).

EndCollectionTime

datetime

Date and time, in UTC, that event batch collection ended.

To troubleshoot event arrival and notification delivery, you sometimes need an event batch ID to use as input to another stored procedure, such as NSEventBatchDetails. This stored procedures lists the event batch IDs for events submitted by a specific event provider to a specific event class.

If you insert events directly into the view named after the event class, the event provider is NULL, and you cannot use this stored procedure. Instead, you can simply query the view.

Notification Services creates the NSEventBatchList stored procedure in the application database when you create the instance. When you update the application, Notification Services recompiles the stored procedure.

This stored procedure is in the application's schema, which is specified by the application's SchemaName property. If no schema name is provided, the default schema is dbo.

Execute permissions default to the NSAnalysis database role, the db_owner fixed database role, and the sysadmin fixed server role.

The following example shows how to run the NSEventBatchList stored procedure for the Notification Services tutorial sample.

EXEC NSEventBatchList N'WeatherSPEventProvider', N'WeatherData';

Release History

5 December 2005

New content:
  • Added information about the event provider value for events inserted directly into the event class view.

Community Additions

ADD
Show:
© 2014 Microsoft