Solved

Auditng SQL Agent Jobs

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

815 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

9 Experts available now in Live!

Get 1:1 Help Now