• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1991
  • Last Modified:

v2008...syspolicy_purge_history

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?
0
dbaSQL
Asked:
dbaSQL
  • 3
  • 2
  • 2
2 Solutions
 
tbsgadiCommented:
0
 
chapmandewCommented:
It is a system thing...its not something you did.
0
 
dbaSQLAuthor Commented:
tbsqadi, chap... need i just leave it be?
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
tbsgadiCommented:
I wouldn't get rid of it!
0
 
chapmandewCommented:
yes, just leave it be.  its fine.
0
 
dbaSQLAuthor Commented:
thank you both
0
 
tbsgadiCommented:
Glad to help!
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now