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.