Problem: One or more of your operators are not getting notifications from SQL Server agent alerts or jobs. Solution: This could be for a number of reasons, but more than likely it is because an operator or alert is disabled, or both. Let’s use the query below and determine what is causing the underlying problem …
T-SQL script showing why SQL Server operators may not receive notifications Read More »
Problem: Sometimes SQL Server agent jobs do not work as expected due to either syntax or logical errors. In this blog post, I attempt to show you how to identify SQL Server agent jobs that do not provide the desired outcome as a result of logic errors, that is, jobs in which some steps ‘on …
Identify SQL Server agent jobs that do not run all steps Read More »
Another release of SQL Agent Insight (SAI) is upon us. Since I’ve started to use git as a means of software version control earlier this year, I’m hoping that I can make releases to SAI more frequently. I can see the value and benefits in git, but the process has definitely taken some time to …
