SQLTeam.com | Weblogs | Forums

Identify and re-run failed subscription jobs in failover


Hi All,

We have failover set up with 2 Nodes and 1 DR. Whenever failover happened the SSRS subscription agent jobs running during that time all failed. How do I confirm if failover happened then re-run the subscription jobs or at least notify the user that failover happened from Node1 to Node2 . So that user will check if any subscriptions were running during that time and if yes then he will re-run those.



are these schedule jobs that send ssrs or are these ssrs subscriptions?


These are SSRS subscriptions.