Post reply

alert configuration

  • May 28, 2013 at 12:48 am

    #394857

    i need to setup alert when the sql server is shutdown and server is up , how to achieve this

  • May 28, 2013 at 12:54 am

    #1618863

    Use WMI or powershell (for example every minute, depending on the requirements) from a central server to monitor the status of the SQL Engine service on a remote server. When status "started" the SQL server is up. Else there's a problem in connecting to the remote server (status can not be read) or the SQL server is down (status = stopped, pending, etc.). You can create an alert when the status has changes relative to the previous monitored status.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • May 28, 2013 at 12:57 am

    #1618864

    thanks for ur reply , how to do an u pls expalin ?

    or esle is any powershell script to acheieve this ?

  • May 28, 2013 at 1:02 am

    #1618867

    I don't have powershell experience yet, but I think http://technet.microsoft.com/en-us/library/ee176858.aspx could give you a start. There are also a lot of other resources on the web. Just google around 😉

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply