Sql server job scheduler question

  • Folks,

    I know that we can kick off batch files and exes through the sql server job scheduler using EXEC xp_cmdshell ...

    Is there a way to accomplish the following through Sql server job scheduler

    kickoff an exe on a remote machine meaning execute the exe on another machine (run it from the remote machine not run from the current machine)

    Thanks

    smx

  • You need a utility like RCMD that will allow remote command line execution.

  • is rcmd available on a win 2003 machine

    can we use rcmd from sql server job scheduler ?

    any thoughts would be appreciated

    thanks

  • RCMD is a command line utility that remote executes a command on another machine. There are dozens of tools like it available. Look at what is in the server 2003 resource kit - I think it comes with something.

    You can run anything that can be run from the command line using the SQL Agent - assuming you have permissions set up appropriately.

  • mike, thanks for your reply..in win 2003 i did check the windows recource kits\tools

    I could not find an equivalent for the rcmd

    i found elsewhere that there is a remote.exe but that is bit different.

    do you have any suggestions ?

    thanks

  • It looks like remote.exe is the correct utility from MS.

    There are third party utilities available also - search in your favorite search engine.

  • here is what I did

    used PsExec

    I setup a sql server job with the following

    EXEC xp_cmdshell 'c:\psexec.exe -s \\machineName-u "uname" -p "pwd" -accepteula C:\RemoteProgram.exe'

Viewing 7 posts - 1 through 6 (of 6 total)

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