Post reply

Calling a script on remote linux machine

  • June 19, 2014 at 9:01 am

    #290201

    I have two machines, one has sql server 2008 the other one has linux. I have a batch linux commands script file that sits on linux machine and do some work on linux machine, i need to call this script file in a sql server job after some pre-steps are performed.

    So my question is how can we run a script file on a remote linux machine from sql server?

  • June 19, 2014 at 9:19 am

    #1723313

    Have you tried plink from the makers of PuTTY? http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

    You should be able to run the script on the linux machine like:

    plink.exe -ssh -pw pass -noagent user@linux-server /path/to/your/script/make-live

    You can schedule plink using SQL Agent or call it using xp_cmdshell

  • June 19, 2014 at 9:34 am

    #1723317

    Thanks a lot. Do you know the command to run plink from sql agent?

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

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