Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    2

    Question Unanswered: Query/Report for 'Owner' of all SQL Jobs

    Is there a query/report that I can run against all our SQL servers to see who the 'owner' of each job is?

    If so, can this be run in SQL Server Enterprise Manager 8, SQL Server Management Studio or Hyena?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Usual caveats re querying system tables (run at own risk etc):
    Code:
    SELECT J.name AS JobName
     , L.name AS JobOwner
    FROM msdb.dbo.sysjobs_view J
      INNER JOIN
     master.dbo.syslogins L
      ON J.owner_sid = L.sid
    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2006
    Posts
    2
    Thank you very much! I'm just a newbie DBA admin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •