Author name: Brent Sodtke

T-SQL script to show SQL Server agent jobs that are enabled but do not have notifications

Problem: SQL Server Agent jobs on your server are enabled, they are scheduled, and run as planned, but do not have notifications. For mission critical jobs, not having a job notify users can be costly. Why is this a problem? No DBA wants to have bad optics around themselves or their team. It is crucial …

T-SQL script to show SQL Server agent jobs that are enabled but do not have notifications Read More »

T-SQL script to show SQL Server agent jobs that are enabled but do not have a schedule

Problem: SQL Server Agent jobs on your server are enabled but they do not run at the scheduled date/time. Why? There could be a number of reasons, one of which could be because the underlying schedule is not enabled as we’ve seen in this post. However, some jobs may not run (even though they are …

T-SQL script to show SQL Server agent jobs that are enabled but do not have a schedule Read More »

T-SQL script to show all disabled SQL Server Agent schedules that have jobs

Problem: SQL Server Agent jobs on your server are enabled and have at least one schedule assigned to them, but they do not run at the scheduled date/time. Why? There could be a number of reasons, but one that is easily overlooked is because an underlying schedule is disabled. The following script when run on …

T-SQL script to show all disabled SQL Server Agent schedules that have jobs Read More »