Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

NSQuantumFailures (Transact-SQL)

SQL Server 2005

Returns information about failed generator quanta. Notification Services considers a quantum failed if the quantum cannot complete required processing.


[ application_schema_name . ] NSQuantumFailures

The NSQuantumFailures result set is ordered by QuantumId.

Column Name Data Type Description

QuantumId

int

Unique ID of a quantum. You can supply this ID to the NSQuantumDetails stored procedure to obtain additional information about the quantum.

QuantumStatusDescription

nvarchar(255)

Text that describes the current status of the quantum.

QuantumStartTime

datetime

Start time, in UTC, of the time period that the quantum represents.

QuantumEndTime

datetime

End time, in UTC, of the time period that the quantum represents; the end time is the start time plus the quantum duration.

ExecutionTimeInMS

int

Number of milliseconds to process the quantum.

ExecutionStartTime

datetime

The real date and time, in UTC, at which the generator started processing the quantum.

ExecutionEndTime

datetime

The real date and time, in UTC, at which the generator finished processing the quantum.

Notification Services creates the NSQuantumFailures 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 SchemaName element of the application definition file (ADF). If no schema name is provided, the default schema is dbo.

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

The following example shows how to create the failed quantum report for an application.

The application uses the default SchemaName settings, which places all application objects in the dbo schema.

EXEC dbo.NSQuantumFailures;

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.