locked
ping between 2 sql servers RRS feed

  • Question

  • Hi There,

    I need to start a ping  between 2 sql servers when the lost is 3 or 5 % i need to be send for me email telling me that there is netwrok problem.

    Kindly if this does not belong to this forum apreicate transfering it to the correct one

    Monday, August 30, 2010 11:53 AM

Answers

  • This should give you a good start. Insert the output of the below query to a table and schedule a job to run it every minute.

     

    xp_cmdshell 'ping 10.122.1.99 -n 5'

    -n = Number of echo requests to send.

     

    If all 5 echo requests return anything apart from "Reply from...", then trigger the email.

     




    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
    • Marked as answer by Mr.Khaled Friday, September 24, 2010 1:57 PM
    Monday, August 30, 2010 1:29 PM