• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 530
  • Last Modified:

Auditng SQL Agent Jobs

Hello Everyone,

I have a project where I need to audit changes to my SQL Agent jobs.  I will need to be able to query on when, what and who made the changes.  Is there a way to write the SQL Agent logs to a SQL table so that I can query on it?  Or is there a better way to audit the SQL Agent Jobs so that I can query on it?

Thank You!
0
cyardley
Asked:
cyardley
  • 2
  • 2
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
Here is a really nice blog on the topic: http://www.bimonkey.com/2009/12/sql-server-2008-auditing/
MSDN: http://msdn.microsoft.com/en-us/library/cc280386.aspx

The blog post takes you step-by-step through creating the audit table and subsequently the audit on update of UPDATE ON OBJECT::[dbo].[sysjobs] BY [public].
0
 
cyardleyAuthor Commented:
Thank you mwvisa1!
I appreciate your response.
I was pulled into a higher priority issue this morning.  I will review the links that you provided and respond later today.  
0
 
Kevin CrossChief Technology OfficerCommented:
Sounds good and good luck! When you get back to this, the main one is the first. The second will be for full understanding of how Audit works in SQL 2008 per MSDN.
0
 
cyardleyAuthor Commented:
That worked.  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now