NSEventBatchView

  • Article

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