SQL Response will only e-mail you on the first occurence of the alert until the alert is cleared. The reasoning behind this is that if you had a CPU that was spiking, you could potentially end up with 400 e-mails in you inbox before you clear the alert.
Greater customizaion of e-mail behaviour is something that is scheduled for evrsion 2 of the tool though, as various people have reported that they would like the more control over this.
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569