I have several databases with scheduled agents that are set to run on “serverA.” We are setting up a clustered server environment with new servers “serverB” and “serverC.” When the databases are replicated to the new servers, the agents I assume will still be set to run on “serverA” (unless of course we change them).
Once all databases have been replicated to serversB and serverC, we plan to shutdown/remove serverA. What will happen to all those agents that are scheduled to run on serverA? Will they fail? If so, is there a way to replicate a bunch of databases from serverA to serverB and have it change all the agents “run on” location or do we have to manually edit each one?