Decision based on Monitor Response

Thanks for the reply,

 

 

Basically i want to use the MSSQL Monitor to monitor on of my servers. I am using a Database Query and return string to check the health. Based on the return strings, we want to do some actions -

 

 

If return string is xyz - Action - Disallow any new connections and monitor the node for current active connections till it goes to zero. Once it reaches zero, take the node offline.