I have a scenario where I have two job servers (one active and one is passive state), both are configured with similar machine roles, both are in different data centers.
Currently I want to failover my primary job server to the passive one by changing FQDN of the server from the desinger (Changing parameters Full Server Name and Executing server).
I have below questions in my mind regarding my approach:
- Is this technically the righ approach to failover jobserver with minimum number of steps?
- Provided I have already pending job queues on active job server, will those jobs be switched to passive one or not?
- How SQL processing server will communicate to my passive server? as earlier both my active job server and other job server which has role of SQL processing server were in the same data center and there was no communication barier whatsoever.