Post reply

PSTOOLS (PsExec) and SQL Server Agent 2008

  • August 3, 2010 at 2:07 pm

    #387493

    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

    #1201798

    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

    #1202054

    Excellent thanks that was it!

    Steve

  • August 5, 2010 at 10:08 am

    #1202896

    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