Craig_hannagan
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can check in the Log or.......... u can write an audit trigger on the table sysjobs
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
ASKER
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