syspolicy_purge_history
This is a new job that is created by default on SQL Server 2008. By default, the job will most likely fail unless you fix it.
Where it breaks is on STEP 3, which is a Powershell command. It does not reference the correct SQL Server object. Change it to the following to fix it:
(Get-Item SQLSERVER:\SQLPolicy\COMPUTERNAME\DEFAULT).EraseSystemHealthPhantomRecords()
The purpose of this job is to purge unneeded information coming from SQL Server 2008’s new Policy Management features.
Categories