Audit SQL Job Changes - How?

• dbajunior

  SSCrazy

  Points: 2307

  More actions

  January 24, 2012 at 9:45 am

  #249718

  We are running SQL 2008 R2. Yes, I have tried Change Data Capture and SQL Audit , but I need more detail than what they provide. Basically, whenever someone updates, adds, deletes a SQL job, I want to know who did it (not in CDC), when they did it, and exactly what change (not straightforward in SQL Audit) was performed. Any ideas?

• umasingh

  Ten Centuries

  Points: 1182

  More actions

  January 24, 2012 at 12:05 pm

  #1437884

  Check this

  http://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/

• dbajunior

  SSCrazy

  Points: 2307

  More actions

  January 24, 2012 at 12:53 pm

  #1437910

  Thanks - but I am not finding any information in this article related to tracking job changes, or did I miss something?