Restart SQL 2008 Audit Policy and Job

Rating: No reviews yet
Downloads: 159
Released: Feb 18, 2012
Updated: Jul 15, 2013 by ashammout
Dev status: Stable Help Icon

Recommended Download

Source Code Restart SQL Audit Policy and Job
source code, 4K, uploaded Feb 18, 2010 - 86 downloads

Other Available Downloads

Source Code SQL Audit Policy status
source code, 14K, uploaded Feb 18, 2010 - 24 downloads
Source Code Audit Alert
source code, 1K, uploaded Feb 18, 2010 - 26 downloads
Source Code Audit Job
source code, 4K, uploaded Feb 18, 2010 - 23 downloads

Release Notes

This folder contains three pieces of source code:
  • Server Audit Status (Started).xml - Import this on-schedule policy into your server's Policy-Based Management as it will determine if the audit is enabled and able to write to the file system.
  • Create Audit Job.sql - This is a SQL Server Audit job that will execute the noted policy.
  • Create Audit Alert.sql - This is a SQL Server Audit job that will create an audit alert.

Together these three source components will (whenever manually executed or scheduled) determine if all of the audits on your server are able to write to the folder. If they are not, they will send out an alert as well as stop and restart the audit job re-initializing it so that way the audits will start writing again.

Reviews for this release

No reviews yet for this release.