MS SQL Server AlwaysOn high-availability groups – job monitoring and Schwenk

Monitoring processes are set up for the SQL server AlwaysOn high-availability groups used by the customer; these processes monitor cross-database SQL server agent jobs for relevance to the corresponding databases under AlwaysOn and to establish whether the jobs have been manipulated. This ensures that the jobs are implemented redundantly and in the same version in all replicas. Furthermore, modules are implemented to ensure, in the event of a failover that the relevant jobs are activated on the new primary replica and are deactivated on the new secondary replica.