Post reply

Running remote batch files using jobmanager

  • January 14, 2010 at 8:57 am

    #215424

    Hi,

    Can anyone help me with a problem concerning running batch files on a remote server.

    We've got a clusterd sql server 2005 64-bits environment on windows 2003 and want to execute a remote batch file using de jobmanager in sql server. Has anyone got an idea on how to handle this.

    kind regards,

    Bryan

  • January 14, 2010 at 3:17 pm

    #1103992

    Here is what I do.

    1. Create a Credential in SSMS under security (needs to have access to the remote server)

    2. Create a Proxy in SSMS under SQL Server Agent to use the Credentail you just made

    3. Then in your job step you can select "RUN AS" and that proxy you just made should show up instead of "SQL Server SQL Agent Service Account"

    I actually started using power shell scripts instead of CMDEXEC

  • January 17, 2010 at 4:45 am

    #1104690

    Hi,

    thanx for the solution.

    bryan

Viewing 3 posts - 1 through 2 (of 2 total)

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