Trying to use Custom Procedure Alert - Single Alert Status Return with problems

ksherrer

I am tying to create a custom alert with single alert status return, and have created a procedure with output parameters as required, but are getting The procedure call does not contain the required #ALERTVALUE# parameter.  I am fairly certain that I am just not calling the procedure correctly from the Alert Parameters section and can find no documentation or examples anywhere to help. 

My procedure signature is:

ALTER PROCEDURE alert.OrdersProcessing

  @ALERTVALUE varchar(15) OUTPUT,

  @ALERTSTRING varchar(200) OUTPUT

AS

and in alert parameters I have simply put... alert.OrdersProcessing

mandevil

For single metric alerts, we are expecting just one output (a numeric).

For multi numeric alerts, you can have output as 1 alphanumeric and 1 numeric output in that order.

In your case, we're trying to parse 2 outputs where we're only expecting 1.

Try switching to multi numeric alert and you can have your first output be "alert. orders processing" and your second some numeric. See if that gives you the desired results.