I wanted to find out who created and also updated a particular job, I have tried to run the following script but I wanted to know if there are other ways please?
SELECT l.[name] AS 'OwnerName', *
FROM MSDB.dbo.sysjobs j INNER JOIN Master.dbo.syslogins l ON j.owner_sid = l.sid ORDER BY j.[name]
Thank you in advance!