List of jobs associated with database in SQL Server

Introduction

As a DBA I was asked to list out all job in a production SQL Server with respect to the database. Approx 200+ jobes were running and 20+ databases were online. Task seems not so hard, but as I am not so good in query writing. Google was my first and last hope. After a couple of searches, I found two wonderful scripts from a blog. Below both the script will list out jobs associated with the database in a SQL Server.

Script 01

Below query becomes very handy when it is required to list all the jobs residing on a specific database.

Result

Script 02

If it is required to get the complete list of jobs on a server along with the database they reside on, below query helpful.

Result

Source: http://j.gs/DGar

Facebook Comments Box
Please like or share this post if you found it helpful, thank you.
Share on Facebook
Facebook
0Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
Email this to someone
email
Print this page
Print

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *