Availabiltiy Agent is a T-SQL script that is designed to be created as a stored procedure and referenced inside a SQL Agent Job, The agent job will then run every nMinutes to disable jobs on the secondary node that would otherwise cause a job failure.
The script can be downloaded from the projects GitHub, the link of which can be found in the sidebar of this post.
When running this script if the an object exists in the DBA_Tasks database under the schema DBA with the name DBA.ExcludedJobCheck it will be dropped and this stored procedure created in it’s place.
These steps should be first carried out on the primary node in your availabiltiy group.
@database_name=N'DBA_Tasks' to the database name of your choosing.
Once the soloution has been installed, you should find a table inside the database called
[dbo].[ExcludedJobs] this holds all of the agent jobs you want to be in scope of the soloution.
To add a job simply run the below insert adding in the name of your jobs where required
INSERT INTO [dbo].[ExcludedJobs] ([Job_name])
If you have some jobs already in this table from a previous installation that you would like to move out of scope, simply set the Active flag to 0
UPDATE [dbo].[ExcludedJobs] SET Active = 0 WHERE ID = 1
Setting the active flag to 0 will ensure that the job isn’t in scope of the soloution when it runs, this will leave the agent job active on all nodes in the availability group.