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


Comments

Leave a Reply

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