Show SQL Server Job Information

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.

Managed Services

If you do not understand your computer systems or your organization has computer maintenance needs, contact us and we'll schedule a free consultation to offload the computer headaches from you.

View details »

Database Administration

Need some assistance with a database or database maintenance? We can help with that and anything else related to databases.

View details »


Not sure how this could help you? Let us explain the benefits of virtualization and be sure you are using your hardware properly.

View details »