SQL alert for a stored procedure?
- by superdupersomething
I have a SQL 2005 setup and am rather new :)
Been cracking at this for a few hours and I just need some help.
I have been able to setup alerts successfully for the standard "SQL server performance events", its fun. So I already have email alerts working.
However I need the alert thing to run a stored procedure I have created, and depending on its output it will alert me or not via email.
So far I have been trying to use the WMI events, but I keep getting an 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 the correct syntax"
the query definitely works so I have no idea.. is there a different way to do this?