Pro SQL Server 2008 Policy-Based Management

Chapter 5. Receiving Alerts for Policy Violations

One of the benefits of using Policy-Based Management is that it eases the administration effort required to manage and control all of the servers in your environment. If you need to continuously check your servers for policy violations, you are just redirecting your administrative efforts. You still have the benefits of managing by intent, but you haven't removed the mundane tasks from your daily routine. Luckily, you can take advantage of several components within SQL Server to receive automatic notifications when policy violations occur, so you can focus on more important things—like where you're going for lunch. With the proper configuration of Database Mail, operators, and alerts, you will ...