So before I stumpled upon SQLjobvis, I used to use Microsoft Excel to create charts and graphical views of SQL Server Agent job schedules. All this time I’ve wasted!
With this tool, I can view all agent jobs on a particular SQL Server, I can see the run duration, I can see when they were successful or when they failed and more. The goal I wanted to achieve with this tool was to be able to see agent job schedule clashes. This isn’t even a manual task where I need to look and see where all the schedules are bunched together. It’s a built in feature of this tool, along the date header it is colour coded to show you where your server is most busiest and least busiest. Perfect!
Aside from the above, you are able to filter the agent jobs shown by certain criteria like failed/long running/clashing. You can filter by categories or even hide disabled or inactive jobs. The tool includes customing the date range viewed and other basic settings.
If you’re looking for a lightweight tool that’s easy to use to see an overview of your SQL Server’s Agent job schedule, this is it. Oh, and it’s FREE!