Posts
19
Comments
28
Trackbacks
1
SQL 2005 Configuring SQL Job to send email notification if it failed.
This are the simple steps to enable it.
1) Run SQL Server Surface Area Configuration - > Surface Area Configuration for features ->
    Select Database Mail - > Check Enable Database mail stored procedures.
2) Open SQL Management Studio - > Management - > Database mail - > Configure SMTP Settings.
3) Go to SQL Server Agent - > Operators - > Create New Operator
4) Go to SQL Job - > In the Notifications, Check email and select the Operator. You can either
select  the option to send notification if job fails / succeeds/ completed.
Lastly, don't forget to restart the SQL Agent.
posted on Wednesday, March 04, 2009 11:24 PM Print
Comments
Gravatar
# re: SQL 2005 Configuring SQL Job to send email notification if it failed.
Freelance DBA
3/5/2009 4:57 PM
BTW for sql server 2008 only first step is different (since sql server surface area configuration is goen in last version)

exec sp_configure 'show advanced options', 1
reconfigure
exec sp_configure 'Database Mail XPs', 1
reconfigure
Gravatar
# re: SQL 2005 Configuring SQL Job to send email notification if it failed.
Freelance DBA
3/5/2009 4:59 PM
BTW, does anybody know if it is possible to use exchange accounts for database mail?
Gravatar
# re: SQL 2005 Configuring SQL Job to send email notification if it failed.
RPaulo
3/5/2009 8:38 PM
Yes you could .. for my SMTP server settings I'm using domain account. domain\login
Comments have been closed on this topic.