This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
Where can I find information on how to configure 2005 SQL server Agent to send email notifications on success or failure of a job?
Hi, 1. First you need to enable the SQL Mail feature through surface area configuration and configure if you have not already configured Find the below article which shows step by step to configure SQL Mail http://www.sql-server-performance.com/articles/dba/email_functionality_p1.aspx http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/2. Then create an operator How to: Create an Operator (SQL Server Management Studio) http://msdn.microsoft.com/en-us/library/ms175962(SQL.90).aspx3. Notify an Operator of Job Status How to: Notify an Operator of Job Status (SQL Server Management Studio) http://msdn.microsoft.com/en-us/library/ms191130(SQL.90).aspxPlease let me know if you have any questins.
