SQL Server – Find Owners of SQL Server Agent Jobs Using TSQL

  By , ,

Find out who are the owners of the SQL agent jobs by running the script below.

SELECT    
    J.name AS [Job Name]
    ,L.name AS [Job Owner]
FROM
    msdb.dbo.sysjobs_view J
    INNER JOIN master.dbo.syslogins L
        ON J.owner_sid = L.sid
GO
Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter

Related posts:

  1. SQL Server – syspolicy_purge_history Job Failed to Run
  2. SQL Server – Check if “Enforce Password Policy” is On Using TSQL
  3. SQL Server – View FileNames and Paths Using TSQL
  4. SQL SERVER – TSQL Script to Change the Compatibility Level of all Databases
Tagged  , , , , , , , , , , , .
Bookmark the permalink.

Leave a Reply

Leave a Reply

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