I have encountered the situation where i need to find out which of our DBA's disabled an SQL job. We start the jobs using MS SQL Server Management Studio in the Job Activity Monitor. You can right click on the job and specify "Disabled"
What i'm looking for is to how to find out a logon id which has disabled the job since all of DBA use their logon to start the studio. This information should be somewhere but it's not easy to find.
Can anybody please pinpoint me to direction where i can at least do some research on this topic.
I don't think you'll find this anywhere unless you actively added an ALL SERVER trigger beforehand that captures this event. The only place I can think of where you might find relevant information is in the servers security-log.
Depending on the trace file size and the periode you are searching for, I would import the trace file in a table in SQL Server and then I would perform a search after "sp_update_job" and "@enabled=0"
this was just assuming that you were taking a profiler trace at that point with the appropriate data. If this data is not available, from what i know, there is no other way finding out who did this.
Need help Auditing transaction log
Posted - 05/15/2012 : 21:15:45
