Skip to content

configure-the-general-properties-of-policy-based-management.md

Latest commit

 

History

History
91 lines (61 loc) · 3.32 KB

configure-the-general-properties-of-policy-based-management.md

File metadata and controls

91 lines (61 loc) · 3.32 KB
title Configure general properties of Policy-Based Management
description Learn how to configure the properties for Policy-Based Management using SQL Server Management Studio (SSMS) or Transact-SQL (T-SQL).
ms.custom seo-lt-2019
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology security
ms.topic conceptual
f1_keywords
sql13.swb.dmf.PolicyManagement.f1
helpviewer_keywords
Policy-Based Management, configure properties
ms.assetid 6d1e0e37-29ea-408a-a055-384984d884be
author VanMSFT
ms.author vanto

Configure the General Properties of Policy-Based Management

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This topic describes how to configure the properties for Policy-Based Management in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

In This Topic

Before You Begin

Security

Permissions

Requires membership in the PolicyAdministratorRole fixed database role.

Using SQL Server Management Studio

To configure Policy-Based Management

  1. In Object Explorer, click the plus sign to expand the server where you want to configure Policy-Based Management properties.

  2. Click the plus sign to expand the Management folder.

  3. Right-click Policy Management and select Properties.

    The following options are available in Policy Management Properties dialog box.

    Enabled
    Specifies whether Policy-Based Management is enabled.

    HistoryRetentionInDays
    Specifies the number of days that policy evaluation history should be retained. If this value is 0 (the default), the history will not be automatically removed.

    LogOnSuccess
    Specifies whether Policy-Based Management logs successful policy evaluations.

    • When this value is false (the default), only failed policy evaluations are logged.

    • When this value is true, both successful and failed policy evaluations are logged.

  4. When finished, click OK.

Using Transact-SQL

To configure Policy-Based Management

  1. In Object Explorer, connect to an instance of [!INCLUDEssDE].

  2. On the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

    -- enables Policy-Based Management   
USE msdb;  
GO  
EXEC dbo.sp_syspolicy_configure   
     @name = N'Enabled',   
     @value = 1;  
GO

For more information, see sp_syspolicy_configure (Transact-SQL).