Skip to content

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

Latest commit

 

History

History
89 lines (59 loc) · 3.09 KB

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

File metadata and controls

89 lines (59 loc) · 3.09 KB
title Configure the General Properties of Policy-Based Management | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology security
ms.topic conceptual
f1_keywords
sql12.swb.dmf.PolicyManagement.f1
helpviewer_keywords
Policy-Based Management, configure properties
ms.assetid 6d1e0e37-29ea-408a-a055-384984d884be
author MikeRayMSFT
ms.author mikeray
manager craigg

Configure the General Properties of Policy-Based Management

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).