April 23, 2008 at 2:40 pm
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
April 24, 2008 at 8:38 am
You need a utility like RCMD that will allow remote command line execution.
April 24, 2008 at 9:29 am
is rcmd available on a win 2003 machine
can we use rcmd from sql server job scheduler ?
any thoughts would be appreciated
thanks
April 24, 2008 at 9:53 am
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.
April 24, 2008 at 10:17 am
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
April 24, 2008 at 10:36 am
It looks like remote.exe is the correct utility from MS.
There are third party utilities available also - search in your favorite search engine.
April 24, 2008 at 2:14 pm
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