NSEventBatchList (Transact-SQL)

  • Article

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

Syntax

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

Arguments

  • [ @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.

Return Code Values

0 (success) or 1 (failure)

Result Sets

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.

Remarks

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.

Permissions

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

Examples

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

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

See Also

Reference

<EventClassName> View
NSEventBatchDetails (Transact-SQL)
Notification Services Stored Procedures (Transact-SQL)
NSEventBatchDetails (Transact-SQL)

Other Resources

SchemaName Element (ADF)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

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