The following is a small T-SQL script that I frequently use to show the jobs on an instance of SQL that are enabled but are not associated with any type of schedule; because the last thing you want is a recently created backup job of your most critical database and to not have it run as planned.

Hopefully you find this script helpful in identifying jobs that could be overlooked by a quick scan of the native job activity monitor, jobs that are enabled but would not normally run. Feel free to use the script in any of your automated daily reports to quickly identify potential problem areas in your environment.
If you have any feedback, be sure to hit up the ‘Contact Us‘ link at the top of the page. Enjoy.

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