Microsoft KB Archive/908360

= How to configure SQL Server Agent to send job status notifications and alert notifications in SQL Server 2005 64-bit editions =

Article ID: 908360

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard X64 Edition
 * Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems

-



SQL Server Agent is not integrated with Database Mail or with SQL Mail in Microsoft SQL Server 2005 64-bit editions. To send any notifications, such as job status notifications and alert notifications, follow the steps in this article to manually configure MAPI for use by SQL Server Agent Mail.

Note In SQL Server 2005 Service Pack 1 (SP1), you can use SQL Server Agent to interact with Database Mail as the mailing system on 64-bit operating systems.



Create a mail account for SQL Server Agent Mail by using Microsoft Outlook Express
To create a mail account for SQL Server Agent Mail, follow these steps:
 * 1) Click Start, point to All Programs, and then click Outlook Express.
 * 2) If the Internet Connection Wizard does not start automatically, click Accounts on the Tools menu.
 * 3) On the Internet Accounts page, click Add, and then click Mail.
 * 4) On the Your Name page, enter the name that you want to use as the sender of all SQL Server Agent e-mail messages in the Display name box.
 * 5) On the Internet E-mail Address page, enter the e-mail account that you want to use to send SQL Server Agent e-mail messages in the E-mail address box. For example, you could enter someone@example.com.
 * 6) On the E-mail Server Names page, click POP3 for the server type in the My incoming mail server is a box.
 * 7) On the Incoming mail (POP3, IMAP, or HTTP) server page, enter the name of the POP3 server.

Note If you are only using this account for SQL Server Agent Mail, you do not have to select a valid POP3 server name. SQL Server Agent Mail does not receive mail.
 * 1) On the Outgoing mail (SMTP) server page, enter the name of the SMTP server that you want to use to send SQL Server Agent Mail messages.
 * 2) On the Internet Mail Logon page, enter the account you want to use to send SQL Server Agent Mail notifications in the Account Name box.
 * 3) Click Next.
 * 4) Click Finish.

How to configure SQL Server Agent Mail with Outlook Express 6.0
If you are using Outlook Express 6.0 or a later version of Outlook Express, you must configure Outlook Express not to send an alert notification when SQL Server Agent Mail accesses your Outlook Express account. To do this, follow these steps:
 * 1) On the Tools menu, click Options.
 * 2) Click the Security tab, and then click to clear the Warn me when other applications try to send mail as me check box.
 * 3) Click OK.

How to use an existing SMTP Outlook Express mail account for SQL Server Agent Mail
If you already have an SMTP Outlook Express profile created, you can use that profile for SQL Server Agent Mail. You must set the SMTP Outlook Express profile as the default account. To do this, follow these steps:
 * 1) Click Start, point to All Programs, and then click Outlook Express.
 * 2) On the Tools menu, click Accounts.
 * 3) In the Internet Accounts dialog box, select the mail account to set as the default account, and then click Set as Default.

Note This account must be a POP3/SMTP account for SQL Server Agent Mail to work.

How to change the name of your default profile for SQL Server Agent Mail
To change the name of your default profile, follow these steps:
 * 1) Click Start, point to All Programs, and then click Outlook Express.
 * 2) On the Tools menu, click Accounts.
 * 3) In the Internet Accounts dialog box, click the Mail tab, select the default account, and then click Properties.
 * 4) In the Properties dialog box, enter the new name for the profile in the Mail account box.

How to select the mail account in SQL Server Management Studio for SQL Server Agent Mail
After you create a mail account for SQL Server Agent Mail, you can configure SQL Server Agent Mail by using SQL Server Management Studio. To do this, follow these steps:
 * 1) In the SQL Server Agent Properties dialog box, click the Alert System tab.
 * 2) Click Enable mail profile.

Note If this option is not available, enable SQL Server Agent Mail by using the Surface Area Configuration tool, and then use the Surface Area Configuration tool to set up a mail profile.
 * 1) In the Mail System list, click SQL Mail.

NoteSQL Mail is the user interface name for SQL Server Agent Mail.
 * 1) In the Mail Profile list, click the Extended MAPI profile that you created in the previous steps.

Additional query words: sqlmail

Keywords: kbinfo kbtshoot kbsql2005setup kbsql2005mail KB908360

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.