May 4, 2005 at 3:37 pm
Hello everyone,
Is it posiible to use perfmon to send an alert when either the SQL Agent and/or SQL Server service is stopped? I tried monitoring the process object using the thread count to trip the alert when it fell to 0 (zero), but it would not fire the alert. Anyone have any suggestions? Thanks in advance.
May 4, 2005 at 4:15 pm
I needed to monitor services over the weekend once and I used Win32_Service object to get status of the services using WMI inside VBscript. You can use sort of Where to specify what service you want. Then when you get a status you may send an SMTP email.
See for example:
or
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnclinic/html/scripting01142003.asp
The first link is just a reference and the second link is a script primer with good example that you may use, see Listing 2 there
Yelena
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply