Solved

Auditng SQL Agent Jobs

Posted on 2011-09-13
4
481 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

856 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