Paul Duffett – Me, myself and MS SQL Server

This is a handy little function that will decrypt the owner_id from the msdb sysjobs table. Just wanted to post it very quickly because I’ve just had to search for it yet again.

SELECT name, suser_sname(owner_sid) as owner
FROM
sysjobs

Enjoy

PD