NSEventBatchList (Transact-SQL)
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
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
5 December 2005 |
|