• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 594
  • Last Modified:

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
0
Craig_hannagan
Asked:
Craig_hannagan
2 Solutions
 
Guy Hengel [angelIII / a3]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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now