<div>
Problem is that SQL Agent jobs aren't triggered by actions so you can't really have this kind of solution.<br />
You may have a SQL Agent job that runs every minute to check if the Primary Replica changed and then execute something when this validation is true.
</div>


Problem is that SQL Agent jobs aren't triggered by actions so you can't really have this kind of solution.
You may have a SQL Agent job that runs every minute to check if the Primary Replica changed and then execute something when this validation is true.

<div>
how to do that? how to check every minute in scripting?
</div>


how to do that? how to check every minute in scripting?

<div>
Well, you'll need to store last status in a table and then compare it with the actual status. When differs then perform what you want to perform.
</div>


Well, you'll need to store last status in a table and then compare it with the actual status. When differs then perform what you want to perform.

<div>
need more detail coding you have before
</div>


<div>
No code. I'm giving you an high-level solution.
</div>


No code. I'm giving you an high-level solution.

<div>
<div class="content wysiwyg-content">
I have a always-on databases, I want to have a script to do<br />
<br />
When the always-on availability &nbsp;group failover is successful from primary to secondary, run this stored procedure. If not successful, do nothing. how to do that? I want to do that in an agent job or something, when the failover happened, automatically kick off this job. My always SQL is 2016 enterprise
</div>
</div>


I have a always-on databases, I want to have a script to do

When the always-on availability  group failover is successful from primary to secondary, run this stored procedure. If not successful, do nothing. how to do that? I want to do that in an agent job or something, when the failover happened, automatically kick off this job. My always SQL is 2016 enterprise

how to do this script?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.