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 »