Policy-Based Management stored procedures (Transact-SQL)

Applies to: SQL Server

SQL Server supports the following system stored procedures that are used for Policy-Based Management.

Penting

Only the Policy-Based Management stored procedures that are documented in SQL Server Books Online are supported. Undocumented stored procedures are used by internal Policy-Based Management components and shouldn't be used to administer Policy-Based Management.

sp_syspolicy_add_policy_category

sp_syspolicy_add_policy_category_subscription

sp_syspolicy_configure

sp_syspolicy_delete_policy_category

sp_syspolicy_delete_policy_category_subscription

sp_syspolicy_delete_policy_execution_history

sp_syspolicy_purge_health_state

sp_syspolicy_purge_history

sp_syspolicy_rename_condition

sp_syspolicy_rename_policy

sp_syspolicy_rename_policy_category

sp_syspolicy_repair_policy_automation

sp_syspolicy_set_config_enabled

sp_syspolicy_set_config_history_retention

sp_syspolicy_set_log_on_success

sp_syspolicy_subscribe_to_policy_category

sp_syspolicy_unsubscribe_from_policy_category

sp_syspolicy_update_policy_category

sp_syspolicy_update_policy_category_subscription

Related content

• Administer Servers by Using Policy-Based Management