I have the same question as chambem9.
I have read Anu's reply but it doesn't seem to answer the question. Anu's answer explains why an e-mail alert will only be sent for the first alert, but it does not explain why the alert itself is not created.
I have the alert setting at 10 seconds. I run a query that takes 15 seconds. No alert is created. I have not configured the e-mail notification and that is not a problem for me - I am just looking at the alerts generated in SQL Response.
I have also read the following thread.
http://www.red-gate.com/MessageBoard/vi ... ning+query
This explains how often the system checks for long running queries, but it doesn't explain why a query that runs for longer than 10 seconds does not generate a query.
I do get some alerts for long running queries, but these all related to queries running for at least 45 seconds.
What am I doing wrong, i.e how do I ensure that I get an alert for any query that runs for more than 10 seconds?