We have a nuget package that contains a Deploy.ps1 that updates a central database server when it’s run. We don’t want to run the tentacle directly on the database server so instead it’s run on one chosen “deploy” server which is actually a CI build agent.
However, we have a number of build agents and ideally we’d like to say “of all the machines in this role, run this step on just one of them”. That way, if the nominated build agent is offline, we can still deploy. Is this possible, or is there another way to achieve the same effect?