Evaluate a Policy-Based Management Policy on a Schedule

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This topic describes how to evaluate a Policy-Based Management policy on a schedule in SQL Server 2017 by using SQL Server Management Studio.

In This Topic

Before You Begin

Security

Permissions

Requires membership in the PolicyAdministratorRole role in the msdb database.

Using SQL Server Management Studio

To evaluate a policy on a schedule

  1. In Object Explorer, click the plus sign to expand the server that contains the policy schedule that you want to evaluate.

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

  3. Click the plus sign to expand Policy Management.

  4. Click the plus sign to expand the Policies folder.

  5. Right-click the policy whose schedule you what to evaluate and select Properties.

  6. On the Open Policy –policy_name dialog box, in the Evaluation Mode list, select On schedule.

  7. Under Schedule, click either Pick to specify an existing schedule or New to create a new schedule.

  8. When finished, click OK.