Use this dialog box to create a new Policy-Based Management policy or to change an existing policy. Use the Against targets and Server restriction areas as a filter to limit policies to a subset of all possible targets. For conditions to be used as target filters, they must be defined on a physical facet, must not contain functions, and must not contain the Like operator. When the system computes the object set for a policy, by default the system objects are excluded. For example, if the object set of the policy refers to all tables, the policy will not apply to system tables. If users want to evaluate a policy against system objects, they can explicitly add system objects to the object set. However, though all policies are supported for check on schedule evaluation mode, for performance reason, not all policies with arbitrary object sets are supported for check on change evaluation mode. For more information, see http://blogs.msdn.com/b/sqlpbm/archive/2009/04/13/policy-evaluation-modes.aspx
You can open this dialog box in several ways.
To open this dialog box
To create a new policy, in Object Explorer, expand Management, expand Policy Management, right-click Policies, and then click New Policy.
To view or change an existing policy, in Object Explorer, expand Management, expand Policy Management, expand Policies, right-click a policy, and then click Properties.
For system policies, all the fields are read-only. The System Policies folder contains policies that should not be deleted or changed through Policy-Based Management. For example, to make sure that monitoring policies that are used in SQL Server Utility Explorer are not incorrectly changed, these policies and their associated conditions can only be changed through Utility Explorer. To view a system policy, in Object Explorer, expand Management, expand Policy Management, expand Policies, expand System Policies, right-click a policy, and then click Properties.
For a new policy, type the new policy name. For an existing policy, the name is displayed.
Select the Enabled check box to enable the policy. Clear the Enabled check box to disable the policy. The Enabled box applies to policy automation. It creates or removes the automation system for the policy. Automation uses the following mechanisms:
On change: prevent
A database trigger enforces compliance.
On change: log only
A notification services event checks for compliance.
A SQL Server Agent job is created to check for compliance on a schedule.
Policies that are run by using On demand evaluation mode do not use this check box.
Select the Policy-Based Management condition that this policy uses. All conditions on the server for the associated Policy-Based Management facet are listed. Click New condition to create a new condition. Click the ellipsis (…) button to change the condition.
Select the target types that are available for this facet to complete a filter expression.
Select the evaluation mode for the policy. Some policies can be checked but not enforced. The evaluation modes are as follows:
Policy will only be run when you run it from the Evaluate dialog box.
Periodically evaluates the policy, records a log entry for policies that have out-of-compliance, and creates a report. Enables the Schedule box.
On change: log only
When changes are tried, this option does not prevent out-of-compliance changes, but logs policy violations.
On change: prevent
When changes are tried, this option prevents changes that would violate the policy.
This option appears when On schedule evaluation mode is selected. Type the name of the schedule, click Pick to select a schedule from a list, or click New to create a new schedule. To enable the schedule area, On schedule must be selected.
Select the kinds of servers that are appropriate for this policy. Options are None or select a condition that filters the possible servers.