I have 3 machines (more in reality but 3 for the purposes of this question) on a network, 2 workstations and a server. The server hosts a Rails app which is visited by users on Workstation A, which allows them to view and analyze data from the server's database.. I've also got a Ruby script on Workstation B that generates data and stores to a database on the server. I want the Rails app to have a function to launch that Ruby script on Workstation B when a user on A clicks a certain button on a page of the Rails app, so that 1. as much of my system is contained in the app as possible and 2. I can avoid having to connect through a remote desktop or even worse, physically going to Workstation B.
I really have no idea how to approach this on even a basic level; I've used PSExec in the past to remotely launch processes, but I don't know if that tool would be viable for this application. If it is I can not image how to use it for that purpose. Can somebody point me in the right direction?