When reviewing SQL Server, sometimes we want to know what SQL Server jobs exist on each server and important information about those jobs, such as schedules, last time run, and other useful information.
We created a stored procedure to help show this information, which you can download and freely use here. This stored procedure has been used on SQL Server 2008, 2008 R2, 2012, and 2014 at the time of this writing and has been useful to find out all kinds of information about jobs. This procedure has helped us quickly find SQL Server jobs with owners that no longer exist, enabled jobs with disabled schedules, disabled jobs, and when jobs run, among other things, in one simple execution.
The procedure is written to show everything it can by default but has parameters to limit the output to enabled or disabled job schedules, enabled or disabled jobs, and/or based on the frequency of when jobs are scheduled to run. We hope you find as much use out of it as we do.