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)