SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Creating and Using Operators

SQL Server operators are collections of contact information and contact time windows for individuals, groups, or systems. These individuals, groups, or systems can be referred to as points of contact. Operators are created to provide notifications to these points of contact. In most cases, jobs and alerts send the notifications. You create operators in SSMS by expanding the SQL Server Agent container in Object Explorer and then selecting the Operators container. From here you can create and manage operators. Exercise 13.6 steps you through the process of creating a fictitious operator named Fred Barney.

EXERCISE 13.6 Creating an Operator

In this exercise, you will create an operator for a fictitious individual named ...