Posts
19
Comments
28
Trackbacks
1
Wednesday, March 04, 2009
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 @ Wednesday, March 04, 2009 11:24 PM | Feedback (3)