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.
T.I.A