Hi,
I am trying to execute a batch file from an sql job, that executes a program that will write some paths into a folder in another server.
When I execute the file with the Windows admin, from a cmd console, it works fine. The Windows admin on my machine has permissions to write on the other server.
But when I execute from sql, it uses the SQL Agent account, which has no permissions on the other server, and I cannot give permissions.
Also, my job has different steps, most of them executing stored procedures from SQL, and only two steps executing external batch files.
Is there a way I could run only those two steps with the Windows admin from the machine on wich SQL resides?
Thank you so much!