 <pre><code>SELECT CASE WHEN ((SELECT Count(*) FROM table) &gt;= '100') THEN 'ALERT' ELSE null END </code></pre> <p>Create a job that runs every 10 seconds/5 seconds or what ever and put in the above query and get it to email if there are results.</p>