I have a select statement: select count(*) from tblReport with (nolock) I set up the monitor. I want to setup an alarm when the result count of this query drops to less than 5. Infact, I have 10 other queries for which I need to do the same thing. How can I do this?

 

Thanks!