Export (0) Print
Expand All

NSEventBatchView

SQL Server 2005

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

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

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.

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

The following example shows how to run the NSEventBatchView.

SELECT * from dbo.NSEventBatchView;

Community Additions

ADD
Show:
© 2014 Microsoft