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 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.
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]