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]

You may also like

• 

  SQL DROP Statement
• 

  SQL GROUP BY Clause
• 

  Different Types of SQL Server Locks
• 

  SQL ALTER TABLE Statement
• 

  SQL UNION Operator
• 

  SQL CREATE TABLE Statement