xp_cmdshell

1 Sep 2005 3:02 PM

marcmc

I need to run xp_cmdshell from a SQLServer Job on Server1 that executes a
batch file on Server2.

Firstly can it be done? If so, any guides/ideas how?
I was thinking of using xCmd or psExec.

This is really urgent if you guys would like a real test, I know it has and
continues to test me to the limits :(

1 Sep 2005 3:16 PM

Jens SÃ¼ÃŸmeyer

It works yes, but under the enviroment of the server1, so everything has to
be stated as of server1, e.g. copy *.* f:\ <-- If f: donÂ´t exists on the
server1 you have a problem, instead using UNC names will work.

--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Show quote

"marcmc" wrote:

> I need to run xp_cmdshell from a SQLServer Job on Server1 that executes a
> batch file on Server2.
>
> Firstly can it be done? If so, any guides/ideas how?
> I was thinking of using xCmd or psExec.
>
> This is really urgent if you guys would like a real test, I know it has and
> continues to test me to the limits :(
>
>

1 Sep 2005 3:44 PM

marcmc

Thankyou Jens

Whate I need is the ability to run a batch file/cmd session on
a remote machine where the program being executed is executed in the context
of the remote machine. Once I find a tool to do that then we can wrap the
xp_cmd shell around it.

I am currently looking at xCmd and psExec. Have you had any experience with
these as I am connecting to the machine but just cannot get the file I want
to run?
The commands ive found on the web are vague.

marc