Sample Header Ad - 728x90

SQL Server Agent job to verify logshipping on multiple databases

0 votes
0 answers
37 views
I'm trying to come up with a SQL script that will verify log shipping on about 100 databases in an instance. I need to be alerted if log shipping is failing, but I do not want 100 plus emails coming in every 15 minutes, so I'd like to have one SQL Server Agent job that checks log shipping logs and if there are < 50 failures in a 30 minute period, then I'll get paged. The problem is that I don't know how to write a SQL script for that. I have tried turning off notifications on all jobs except a handful, but the issue there is that if one of those fails but the others don't, I might not get paged.
Asked by user323060 (1 rep)
Feb 12, 2025, 02:33 PM
Last activity: Feb 12, 2025, 06:02 PM