vCenter SQL Agent Jobs on SQL Always ON or Mirrored SQL

 

If you are using Microsoft SQL Always ON or Mirrored SQL then you need to create vCenter SQL Agent jobs on both primary and secondary SQL servers. During installation of vCenter server it only create Agent jobs on the primary SQL Instance.

You need to manually create vCenter SQL Agent Jobs on secondary SQL instance. Refer below KB for manually creating vCenter SQL Agent Jobs.

https://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1004382

https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2006097

Once you have Jobs created on both the SQL servers, we need to make sure SQL jobs run only on primary SQL server. Because the database will keep running on primary sql server and if Jobs run secondary instance, they are going to fail.

To avoid failure of vCenter SQL agent Jobs, put the condition in Job scripts to Run a SQL Job only when that SQL server is primary SQL instance.

You need to put this condition in all vCenter SQL agent Jobs and on both the primary and secondary SQL servers.

 

Thanks…!