Shelley Allen
SSCrazy
Points: 2146
More actions
November 7, 2006 at 9:46 am
#62666
Is there a script I can run to see who owns a job in SQLServer 2000 SP4?
Ninja's_RGR'us
SSC Guru
Points: 294069
November 7, 2006 at 9:52 am
#670326
Is this what you are looking for?
Select L.Name AS Owner, J.* from msdb.dbo.SysJobs J inner join Master..SysLogins L on J.owner_sid = L.sid
November 7, 2006 at 9:56 am
#670327
That is exactly what I needed. Thank you so much!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply