Great, thanks!

I created a query to look for jobs not owned by SA, and discovered a small "gotcha". A LEFT JOIN would work, of course, but I don't really need it.

--Jobs not owned by sa.

--N.B.! DO NOT JOIN to Master.dbo.syslogins as some websites suggest.

--Using Windows integrated security means that the job owner may be an individual without a specific login, if the login

--was created for a Windows group.

--For example, when I create jobs, the owner defaults to OURDOMAIN\myusername, but there is no corresponding login.

SELECT suser_sname(owner_sid) as OwnerName, *

FROM msdb..sysjobs

WHERE owner_sid<>suser_sid('sa')

Rich Mechaber