Policy-Based Management Stored Procedures (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Important

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 should not be used to administer Policy-Based Management.

sp_syspolicy_add_policy_category sp_syspolicy_rename_policy_category
sp_syspolicy_add_policy_category_subscription sp_syspolicy_repair_policy_automation
sp_syspolicy_configure sp_syspolicy_set_config_enabled
sp_syspolicy_delete_policy_category sp_syspolicy_set_config_history_retention
sp_syspolicy_delete_policy_category_subscription sp_syspolicy_set_log_on_success
sp_syspolicy_delete_policy_execution_history sp_syspolicy_subscribe_to_policy_category
sp_syspolicy_purge_health_state sp_syspolicy_unsubscribe_from_policy_category
sp_syspolicy_purge_history sp_syspolicy_update_policy_category
sp_syspolicy_rename_condition sp_syspolicy_update_policy_category_subscription
sp_syspolicy_rename_policy

See Also

Administer Servers by Using Policy-Based Management