Produces the quantum list report for a Notification Services application. The report contains information about quanta processed during a specified time period, and displays the quanta in the order in which they ran.
NSQuantumList [@StartTime =] 'start_time' , [@EndTime =] 'end_time'
- [@StartTime =] 'start_time'
- Is the starting UTC (Universal Time Coordinate or Greenwich mean time) date and time for the range of generator quanta to be included in the result set. start_time is datetime and has no default value.
- [@EndTime =] end_time
- Is the ending UTC date and time for the range of generator quanta to be included in the result set. end_time is datetime and has no default value.
Return Code Values
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||Quantum starting time in UTC (Universal Time Coordinate or Greenwich mean time).|
|EndTime||datetime||Quantum ending time in UTC; 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||Number of milliseconds to process the quantum.|
|ExecutionStartTime||datetime||Date and time, in UTC, at which the quantum started processing notifications.|
|ExecutionEndTime||datetime||Date and time, in UTC, at which the quantum stopped processing notifications.|
|EventNotificationsGenerated||int||During quantum execution, number of notifications generated from event-triggered rules.|
|ScheduledNotificationsGenerated||int||During quantum execution, 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.|
The NSQuantumList stored procedure is created when you run NSControl Create. It is located in application databases.
To determine the current UTC date and time, run SELECT GETUTCDATE() in SQL Query Analyzer. 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.
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 all quanta that completed between 2:30 and 3:30 A.M. on May 22, 2002.
EXEC NSQuantumList '2002-05-22 02:30:00', '2002-05-22 03:30:00'