With
SQL Server 2008 a new feature “Policy Management” was introduced. When you define a policy, this can be evaluated against targets to check for
compliance. Each evaluation of compliance will be recorded in tables in msdb database:
- syspolicy_policy_execution_history_details_internal
- syspolicy_policy_execution_history_internal
- syspolicy_policy_category_subscriptions_internal
The
purpose of syspolicy_purge_history job is to remove records in
those tables and keep them under reasonable size.
No comments:
Post a Comment