Running a job on one server from another server

• MillerTime

  SSC Veteran

  Points: 234

  More actions

  February 25, 2004 at 10:44 am

  #84702

  Please bear with me.  I'm new to SQL Server.

  Using a job defined with Enterprise Manager,

  I am currently trying to execute an .exe file on one sever from another server.  The problem I seem to be having is navigating to the executable file when some of the folders in the path have embedded blanks in the names.  For example;

  \\Servername\Folder1\Folder 2\another folder\excutable.exe

  Seems the job doesnt like spaces.  I tried having the job run a .bat file on the second server, but seems .bat files have problems with executing on a different server.

  Any suggestions ?

  Thanks.

   

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736210

  More actions

  February 25, 2004 at 1:47 pm

  #495667

  Use quotes around the path

  run \\myserver\c$\program files\microsoft SQL Server\80\tools\isqlw.exe