September 2010
Intermediate to advanced
1704 pages
111h 8m
English
The following sections show an example in which you create a SQL Server Agent Mail operator that SQL Server Agent will notify when a job completes.
First, you need to create an operator. To do so, using the Object Browser, you expand the SQL Server Agent node and then right-click the Operators folder and select New Operator. Then you should name this new operator Test Database Mail Operator and provide an email address for testing purposes in the Email Name text box. You can use any valid email address you can access with your email client software. You click OK to save the new operator.
Next, you need to enable SQL Server Agent to use Database Mail. You right-click the