We have an
.exe file on a server, say Server1 which should be run from a SQL Server job that 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?