Solved

Auditng SQL Agent Jobs

Posted on 2011-09-13
4
447 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
  • 2
  • 2
4 Comments
 
LVL 59

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 59

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now