Wednesday, March 7, 2012

Owner for jobs(Sql2k)

I��m looking for the owner of our scheduled jobs but I can��t work out; Sysjobsteps, sysjobs, sysjobschedules

Sysjobservers, etc.. and neither of them I��ve been able to find this value. I saw owner_sid in hexadecimal notation, nothing else.

Does this search make any sense otherwise sql encrypt this data?Where this data stored is?

Thanks for any comment or though,

this should do:

select [name],suser_sname(owner_sid) [owner]
from msdb..sysjobs|||Thanks for that.

No comments:

Post a Comment