• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2025
  • 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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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