January 26, 2018 at 5:27 am
Is there any way to findout who made last changes in a particular job using SQL Server default trace? Several DBA won't accept rather I just find it from system.
Shamshad Ali Khatri
January 26, 2018 at 5:35 am
Unfortunately not. You'll need to have set something up in advance. I think a trigger on sysjobs would work.
John
January 26, 2018 at 5:35 am
Might be in the default trace, I can't remember if jobs are one of the things it tracks.
Other than that, you'd need custom monitoring
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2018 at 5:58 am
OK, but how to do that? any suggestion, steps, or some reference? which help implement this working...
January 26, 2018 at 6:14 am
John Mitchell-245523 - Friday, January 26, 2018 5:35 AMYou'll need to have set something up in advance. I think a trigger on sysjobs would work.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2018 at 8:36 am
Getting started with the default trace: http://qa.sqlservercentral.com/articles/SQL+Server+2005/64547/
I don't see any events in there that would track jobs.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply