Jobs on Always On cluster, the important part is the check if it is primary USE [msdb] GO /****** Object: Job [_MULTISERVER_JOB_TEMPLATE] Script Date: 14-03-2017 14:15:33 ******/ BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = […]
KB with my experience
Jobs on Always On cluster, the important part is the check if it is primary USE [msdb] GO /****** Object: Job [_MULTISERVER_JOB_TEMPLATE] Script Date: 14-03-2017 14:15:33 ******/ BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = […]