This is for Charlie, per our recent conversation regarding issues with his alert not firing. See the attachment.
I had to take out some site specific information, like our email ip address. I also am using some custom fields that you will probably not have.
Also, this alert won't fire unless it has been at this level for over an hour. However, if you look at the alert manager's active alerts, you'll see it was detected because the alert state is 1 (blue triangle). Once it has met the time requirement, the email will fire (after the 10 minute delay while it's gathering the top 10 processes) and the status will change. We also don't alert after hours because SQL is known to use the entire machine and this frequently happens with SQL jobs that are schedule to run at night.