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.

Syntax


[ application_schema_name . ] NSQuantumFailures

Return Code Values

None

Result Sets

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.

Remarks

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.

Permissions

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

Examples

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;

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

NSQuantumFailures (Transact-SQL)

Reference

Other Resources

Help and Information

Community Additions