I have a need to poll one of our tables for a specific condition, and then email me to respond. I'd like to set this up in sql agent. Basically would like to run this query "SELECT * FROM PSAPMSGSUBCON WHERE SUBCONSTATUS =3 and STATUSSTRING ='WRKNG' and run this like ever 30 minutes.
Appreciate ideas.