SQL SERVER:- How To get List of SQL Server Jobs and Their Owners


With the help of below script we are able to get the SQL Server jobs and respective owner details in SQL Server :-

SELECT sj.name As Job_Name,
sl.name As Job_Owner
FROM msdb..sysjobs sj
LEFT JOIN 
master.sys.syslogins sl 
ON sj.owner_sid = sl.sid

Output:-

 


 

Leave a Reply

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