tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P52

Microsoft SQL Server 2008 R2 Unleashed- P52:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 454 CHAPTER 16 SQL Server Scheduling and Notification Configuring Email Notification The SQL Server Agent can send email notifications it can send email via SQL Mail or Database Mail. SQL Mail was retained for backward compatibility. It utilizes an Extended Messaging Application Programming Interface Extended MAPI interface to send email and requires that you install an email application such as Outlook that supports Extended MAPI communication on the computer that is running SQL Server. Database Mail which is now the recommended mail solution for the SQL Server Agent is the focus of this section. It was added in SQL Server 2005 and it utilizes Simple Mail Transfer Protocol SMTP instead of Extended MAPI to send mail. This simplifies email setup and has many benefits over SQL Mail including the following There is no requirement that an email client be installed on the SQL Server machine. Email is queued for later delivery if the mail server stops or fails. Multiple SMTP servers can be specified so that mail continues to be delivered in the event that one of the SMTP servers stops. Database Mail is cluster aware. Database Mail is disabled by default in SQL Server 2008 but can be enabled using the Database Mail Configuration Wizard. This wizard provides a comprehensive means for configuring Database Mail. The Database Mail Configuration Wizard is not launched from the SQL Server Agent node. Instead you can launch it by expanding the Management node right-clicking Database Mail and selecting Configure Database Mail. This wizard guides you through the configuration of mail profiles SMTP accounts and other options relevant to Database Mail. The Configuration Wizard and many other details related to Database Mail are discussed in detail in Chapter 15 Database Mail. After you set up Database Mail and confirm that it is working properly you can select it as your mail system for the SQL Server Agent to send mail. You do this by right-clicking the SQL Server Agent node in the