How to create a email alerts based on count?

[vivek23]

I need email alert query if count is zero for about 30 mins and i need only one email alert saying count is zero.

For Ex: I have one service whose count is said to be 0 btw 11-11:30 AM, then i must receive email alert as count is zero.

Help me plzzzz....

[ITWhisperer]

I am guessing that you don't have any events for that service, but I am also guessing that there is more than one service and you want an alert if any one of them has a count of zero? If so, why not flip it to do your counts by service and then alert if you don't have a full set of counts e.g. if there are 10 services, if you don't get 10 rows back from the stats count by service, you know at least one of the services is missing?