Running remote batch files using jobmanager

Question

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

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

ggoble Hall of Fame Points: 3337 More actions · Answer 1

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

bryan van ritter SSCrazy Points: 2270 More actions · Answer 2

SSCrazy

Points: 2270

January 17, 2010 at 4:45 am

Hi,

thanx for the solution.

bryan