NSEventBatchView

Contains information about all event batches for all event classes in a Notification Services application.

View Columns

Column	Data type	Description
EventBatchId	bigint	Identifier for the event batch.
EventClassName	nvarchar(255)	Name of the event class for the event batch.
ProviderName	nvarchar(255)	Name of the event provider that submitted the batch of events.
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.
QuantumId	int	Identifier for the generator quantum that produced this event batch.
QuantumStatus	nvarchar(255)	The current status of the quantum. The status can be any of the following values: Started Views materialized Rule firings scheduled Removing data (vacuumer) Successfully completed rule firings Failure after rule firing(s) scheduled Failure after start Failure after views materialized Failure during rule firing(s) NULL

Remarks

All quantum information is NULL if the event batch is submitted when no quantum exists, such as when the generator is not running. For event batches submitted through this view, the provider name is NULL.

Permissions

SELECT permissions default to the NSAnalysis, NSGenerator, NSRunService database roles.

Examples

The following example shows how to run the NSEventBatchView.

SELECT * from dbo.NSEventBatchView;

See Also

Reference

Notification Services Views
Notification Services Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance