August 3, 2010 at 2:07 pm
Is anyone using PSTOOLS with SQL Server Agent? When I use SQL Server agent to launch the program it just runs and shows the beginning screen and does nothing and does not end. When I run the command from the cmd prompt it runs fine.
I am trying to use SQL Server Agent to launch .exe of another server.
Any thoughts or experiences?
Thanks
Steve
August 3, 2010 at 2:46 pm
I believe the latest version of PSTOOLS brings up a license dialog the first time you run it, so you might try logging into that server with the service account and running PSEXEC to make sure that is not a problem.
August 4, 2010 at 6:53 am
Excellent thanks that was it!
Steve
August 5, 2010 at 10:08 am
There is a command line parameter to add or you can perform a registry hack to achieve the same result.
However you may encounter issues if you attempt to start/execute processes on another server. They will randomly hang or fail. If you run into this you will need to capture stdout and stderr for both the psexec command and the remote command as well.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply