You can run the SQL Server Agent without ever setting up an operator, But, you will miss out on one of the most powerful mechanisms withing SQL Server. Operators are the core of yoru notification system. Without an operator, you have no way of being notified of a critical job that failed or when an environmental counter exceeds its threshhold.

Creating an Operator

The steps to creating an operator are as follows:

1. Right click the Operators item and select New Operator as shown in Figure 13.6.
2. Fill in the name of the Operator.
3. Specify the e-mail address.
4. Specify the pager and on duty schedule if available.
5. Specify a net send address if available.

Creating a new operator.

You should set up an email address for this operator. This can be any valid e-mail address. If you have pager capability, you can also configure the pager address. Notice that when you enter a pager address, you can now set up the duty schedule for that pager. This allows you to specify a certain time range during which pager notifications are sent. We will cover the notifications later in the section on alerts.

SQL Server Agent 1 2 3 4 5 6 7 8 9