How can we help you today? How can we help you today?

Custom alerts

Does anyone know if its possible to return a result set as part of the alert?


Regards

Anrew
crimdon
0

Comments

1 comment

Sort by
  • Adam W
    Hi,

    That's not currently possible with custom metrics. The T-SQL on which the custom metric is based must return a single, numeric scalar or NULL value. It can call a stored procedure, as long as the returned value meets the same criteria. It cannot collect multiple values, results containing alphabetic or special characters, or recordsets.

    https://documentation.red-gate.com/disp ... ine+metric

    Hope that helps.

    Thanks
    Adam
    Adam W
    0

Add comment

Please sign in to leave a comment.