Solved

Auditng SQL Agent Jobs

Posted on 2011-09-13
4
500 Views
Last Modified: 2012-05-12
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
Comment
Question by:cyardley
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 60

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 36533704
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
 

Author Comment

by:cyardley
ID: 36535413
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
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36536404
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
 

Author Closing Comment

by:cyardley
ID: 36544203
That worked.  Thanks!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question