We have an exe file on a server, say Server1 which should be run from a SQL job exists on a different server, e.g.: Server2. How can it be done? I know if it's a local file, I can use
xp_cmdshell in the Job step and run the exe file, but in our case, this file exists on a different server. If it's doable, what security permissions should be set up to achieve it?
Thanks for your help.