Return
-
Title
sp_qstatmon script sends out email id as queue name. -
Description
sp_qstatmon script when changed to send notifications to multiple email ids, it assigns wrong values to the script parameters. Script picks up the second email id in the list as the queue name and sends it out in the email notification.
Here is an example of the email notification.
The backlog of messages in the Capture queue (queue name=2145551212@XXX.com) is currently 32599 This exceeds the threshold of 50 for SharePlex running on port 2125 Please take corrective action. -
Cause
Script assigns the second email id in the distribution list as the queue name and sends it out in the email notification.
-
Resolution
Change the script to have email ids in single quotes separated by commas. Script 'comments' in future releases will have this change reflected.
-
Additional Information
# If more than one person needs to get an e-mail notification then add the names below each separated
# by a comma and with no space in between.