Posted on 2009-04-16
what the heck is that? syspolicy_purge_history
SQL Agent job, I did not create... but... I just noticed I've got it.
I am finding very little online in this regard... not much more than this:
This procedure runs periodically via SQL Agent (msdb.dbo.sp_syspolicy_create_purge_job creates a SQL Agent job to run it), and it cleans out the execution history for the Policy-based management. As PBM can run on a scheduled basis to check that your server(s) are abiding by the policies set, you need some way of cleaning out the history if you get too much.
Still pretty new to the land of '08. How did I get this? What is it's purpose, shall I leave it in place?