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
master.sys.syslogins sl 
ON sj.owner_sid = sl.sid




Leave a Reply

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