Find Jobs Name and Owners in SQL Server

JobsOwners

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 SJ.name AS JobName,SL.name 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.

JobsAndOwner

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 [www.SQLServerLog.com]

You may also like...

Leave a Reply

Your email address will not be published.