What I need to do is the following...
Server1 has an SQL db to which requests are submitted into a queue.
Server2 has the .exe's that are to be executed.
The client submits a request to server1 to have 1.exe and 2.exe run with some parameters.
I want server1 to launch 1.exe to run in server2's process space. What is the proper and approved way to do this? I know I could whip up a little service that would run on server2 and wait for requests to run .exe files, but that doesn't seem like a clean way to me. What is the proper way to do this? Effectively I don't want server1 to be running any of these .exe files. (the .exe files are reports that are processor intensive and they fight with sqlservr for processor time).