Deleted SQL Server Agent Job

  • Hi All,

    I was wondering if there is any way of finding out who and when a job has been deleted in SQL Server 2000 and Server 2005 please.

  • Do you happen to have an audit trigger in your sysjobs of the msdb database? If not, then there is no way of knowing.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • Witch-hunt anyone? If you have backups of your msdb database you can restore those starting with your oldest backup in chronological order to a non-critical instance as a database with a different name and see when it disappeared. This method won't tell you who deleted it but it will give you a range of time as to when it disappeared.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply