Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Lesson 2: Evaluate Best Practices Policies on a Scheduled Basis


Applies To: SQL Server 2016 Preview

You can configure scheduled evaluations of best practices policies on one or more instances of SQL Server. To configure best practices policies to run on a scheduled basis, you must import the policies into the target instance.

To deploy scheduled policies to multiple servers, you can import the policies to one instance, configure the schedules for each policy, export the scheduled policies to a folder, and then deploy the scheduled policies to target instances through Registered Servers.


The target instances must be running SQL Server 2008 or a later version. Automation requires the policies to be stored locally on the instance, which is not supported by versions of SQL Server that are earlier than SQL Server 2008.

In this lesson, you will do the following:

  • Import the best practices policies into an instance of SQL Server.

  • Configure the policies to run on a schedule.

  • Deploy the scheduled best practices policies to multiple instances through Registered Servers.

This lesson contains the following topics:

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft