Find Jobs Name and Owners in SQL Server


If you want to find SQL Jobs Name and owners by which particular job is running then you can find the same by joining sysjobs and syslogins from msdb and master database respectively as given below.

SELECT AS JobName, AS Owner
FROM msdb..sysjobs SJ
LEFT JOIN master.sys.syslogins SL
ON SJ.owner_sid = SL.sid

It has returned following output from my test server.


Similarly, you can find the list of all the jobs and their respective owners by simply executing a query. You can also filter the query by using WHERE clause for particular job or owner.

Reference: Manzoor Siddiqui []

You may also like...

Leave a Reply

Your email address will not be published.