Thank you. That should do the trick. I set that up and am waiting for an alert to trigger to test it out.
I now have other alerts that I would also like to set up jobs for but I don't know the query to use. For example, the Full Scans Per Second alert:
The SQL Server performance counter 'Full Scans/sec' (instance 'N/A') of object 'SQLServer:Access Methods' is now above the threshold of 10.00 (the current value is 17.10).
Is there a query that will tell me the table(s) that are being scanned?
In general, is there a way to access the query that is triggering the alerts to be able to get more information from it than the very vague message that it sends?