Sample Header Ad - 728x90

How can I make SQL Server Agent job history available after failing over an AG?

1 vote
1 answer
582 views
I am implementing a new HA/DR architecture using Always On AGs for use in both a HA a DR scenario. I have mastered a mechanism to ensure that jobs are disabled on the secondary replica and enabled when a failover takes place but now realise that, once this happens, no job history will be available. Job history is essential to determine what hadn't run or failed on the now defunct primary and needs to be run on the new primary. I am struggling to find any documentation about how to overcome this and make that data available on the new primary. Has anyone been confronted with this and how did you get around it?
Asked by Dave (11 rep)
Jan 16, 2019, 11:26 AM
Last activity: Jul 1, 2025, 08:11 PM