how to give multiple server names at a time in osql commands

• anilkumar.goodapati

  Grasshopper

  Points: 11

  More actions

  November 11, 2009 at 10:20 pm

  #72550

  osql -S"servername" -Uusername-Ppassword -dmsdb -ijob_stop.sql -olog.txt

  type log.txt>>finallog.txt"

  by using the above command we can only stop the one server job at a time. But i want to execute this for multiple servers at the same time. is there any solution for that one.

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  November 16, 2009 at 10:57 pm

  #1080041

  Nope.. Sorry..

  CEWII

• Bill Scott

  SSCrazy

  Points: 2338

  More actions

  November 18, 2009 at 10:51 am

  #1081075

  write a batch file one osql per server...

  osql -S"server1" -Uusername-Ppassword -dmsdb -ijob_stop.sql -olog.txt

  type log.txt>>finallog.txt"

  osql -S"server2" -Uusername-Ppassword -dmsdb -ijob_stop.sql -olog.txt

  type log.txt>>finallog.txt"

  osql -S"server3" -Uusername-Ppassword -dmsdb -ijob_stop.sql -olog.txt

  type log.txt>>finallog.txt"

  osql -S"server4" -Uusername-Ppassword -dmsdb -ijob_stop.sql -olog.txt

  type log.txt>>finallog.txt"