Custom alerts

crimdon

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


Regards

Anrew

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