October 29, 2013 at 4:38 am
Dear All,
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]
GO
Thank you in advance!
October 29, 2013 at 4:55 am
If you don't have any logging and auditing set up on your server, you may be out of luck. You could try the default trace, if it goes back far enough.
John
October 29, 2013 at 9:58 am
Thank you for your help, I will have to create a trigger as I don't have any audit on the jobs.
October 29, 2013 at 10:16 am
I don't recommend using triggers. By the time you've thought of everything you want to audit, you'll have so many triggers that you won't know how to manage them all. You can build your own solution using Service Broker or any of several other technologies built into the SQL Server platform. If you don't want to do that, there are several third party tools that will handle it all for you.
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply