I have a use case where we have a lot of ETL jobs that run on a couple of machines. I wanted kick around ideas on how we could execute those processes based on the machine that has the most available resources.
For example we connect to remote01 and see that it has 100 ETL processes running and remote02 has 50, so we would want to execute this action on the remote02 server.
The only thing I could think of is something like creating a workflow to with a task to check 01 and 02 and then determine where the ETL task should run, but I wanted to see if there might be a simpler way of doing this.