Discovering Job Owners

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  May 17, 2007 at 8:00 am

  #76709

  Hello,

  Are there system tables/procs in the MSDB database that contain data on the owner of SQL Server 2000 Jobs in the form of the the owners domain\login (or just login)?  I've checked BOL, Google, and have skimmed through the system procs and tables, but I have not come across anything obvious.

  Thank you for your help!

  CSDunn

• Adam Angelini

  SSCrazy Eights

  Points: 8548

  More actions

  May 17, 2007 at 9:07 am

  #707181

  this should do it

  SELECT j.NAME,l.name FROM msdb..sysjobs J

  INNER JOIN master..syslogins l ON j.owner_sid = l.sid

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  May 17, 2007 at 1:01 pm

  #707241

  That's it! Thanks!

  CSDunn