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