Find out who deleted SQL 2005 Job

Hi,
One of our admins has deleted a SQL Job from our SQL 2005 Server (Std).
I would like to know if it is possible to find out which admin deleted the job and if also possible when?
Regards Craig
Craig_hannaganAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
unless you analyse the transaction log backup of the msdb database (if you had implemented that), you cannot find that out, AFAIK
0
 
vinurajrCommented:
you can check in the Log or.......... u can write an audit  trigger on the table sysjobs
0
 
RiteshShahCommented:
If you have not implemented sysjobs trigger so far and msdb database transaction log backup than right now there is no change to look at it if it has been done in past but you can do it as a future precautions
0
 
Craig_hannaganAuthor Commented:
Thanks for all your replys. I have not been doing transactional log backups on the msdb database. I will from now on though. Thanks for the info about triggers etc, looks good. Cheers Craig
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.