Share via


NSQuantumList (Transact-SQL)

Produces the quantum list report for a Microsoft SQL Server Notification Services application. The report contains information about the quanta processed during a specified time period, and displays the quanta in the order in which they ran.

Syntax

[ schema_name . ] NSQuantumList 
    [ @StartTime = ] 'start_time',
    [ @EndTime = ] 'end_time'

Arguments

  • [ @StartTime = ] 'start_time'
    Is the start date and time, in UTC (Coordinated Universal Time), of a time period to be included in the result set. Quanta represent time periods, but are not necessarily executed at that time.

    start_time is datetime and has no default value.

  • [ @EndTime = ] 'end_time'
    Is the end date and time, in UTC (Coordinated Universal Time), of a time period to be included in the result set. Quanta represent time periods, but are not necessarily executed at that time.

    end_time is datetime and has no default value.

Return Code Values

None

Result Sets

The NSQuantumList 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.

StartTime

datetime

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

EndTime

datetime

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

SkippedCount

int

Number of skipped quantum periods prior to this quantum.

QuantumStatusDescription

nvarchar(255)

Text that describes the current status of the quantum.

ExecutionTimeInMS

int

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

ExecutionStartTime

datetime

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

ExecutionEndTime

datetime

Date and time, in UTC, at which the quantum stopped processing notifications.

EventNotificationsGenerated

int

During quantum execution, the number of notifications generated from event-triggered rules.

ScheduledNotificationsGenerated

int

During quantum execution, the number of notifications generated from scheduled subscription rules.

EventChronicleRuleFiringsSkipped

nvarchar(255)

Indicates whether event chronicle rule firings were skipped due to the chronicle quantum limit for the application. Possible values are Yes and No.

SubscriptionRuleFiringsSkipped

nvarchar(255)

Indicates whether subscription rule firings were skipped due to the subscription quantum limit for the application. Possible values are Yes and No.

Remarks

Notification Services creates the NSQuantumList 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.

The @StartTime and @EndTime values filter the results based on the quantum StartTime and EndTime values, not the ExecutionStartTime and ExecutionEndTime values. You can view these values for a quantum by running the NSQuantumDetails stored procedure.

To determine the current UTC date and time, run SELECT GETUTCDATE() in SQL Server Management Studio. The current UTC time is derived from the current local time and the time zone setting in the operating system of the computer on which SQL Server is running.

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 all quanta that started and finished executing between 2:30 and 3:30 A.M. on May 22, 2004 (UTC).

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

EXEC dbo.NSQuantumList 
    @StartTime = '2004-05-22 02:30:00', 
    @EndTime = '2004-05-22 03:30:00'

See Also

Reference

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

Other Resources

Notification Services Performance Reports
SchemaName Element (ADF)

Help and Information

Getting SQL Server 2005 Assistance