Thanks for taking the time to share this.
I am having problems setting up the alert. I get this error:
The @wmi_query could not be executed in the @wmi_namespace provided. Verify that an event class selected in the query exists in the namespace and that the query has has the correct syntax. (Microsoft SQL Server, Error:22022)
I made sure the WMI namespace was \\.\root\cimv2 and used the query you provided.
The SQL Server Agent service account is a domain account. We are running SQL Server 2008 Standard, SP2 (10.0.4000)
Found nothing in the SQL log or Windows events logs.
Any ideas on what I did wrong? Thanks.