This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

SQL Agent Job completion notification

Question
0

Sign in to vote

Isn't there a way for SQL Agent to send a success email if a job is successful, and a failure email if the same job failed? I only see how to send one or the other. I could set up additional tasks and route the job to a success task or failure task upon success or failure, but with all of the completion options, event notifications, etc, it seems like there should be an easy built in way to simply send a success or failure notification.

Wednesday, June 29, 2011 9:20 AM

Answers

0

Sign in to vote
On the left hand (of the job's property) tab select notification to specify an operator name to be notified when job is failed

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
- Proposed as answer by Satish Kumar Gajula Wednesday, June 29, 2011 12:56 PM
- Marked as answer by Peja Tao Thursday, July 7, 2011 1:11 AM
Wednesday, June 29, 2011 9:38 AM

Answerer
0

Sign in to vote
Configure SQL agent to send emails: - http://support.microsoft.com/kb/908360

How to: Notify an Operator of Job Status (SQL Server Management Studio) : - http://msdn.microsoft.com/en-us/library/ms191130.aspx

Harsh Chawla Personal Blog:-http://blogs.msdn.com/batala Team Blog:- http://blogs.msdn.com/b/sqlserverfaq/
- Proposed as answer by Peja Tao Friday, July 1, 2011 5:32 AM
- Marked as answer by Peja Tao Thursday, July 7, 2011 1:11 AM
Wednesday, June 29, 2011 2:14 PM

All replies

0

Sign in to vote
On the left hand (of the job's property) tab select notification to specify an operator name to be notified when job is failed

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
- Proposed as answer by Satish Kumar Gajula Wednesday, June 29, 2011 12:56 PM
- Marked as answer by Peja Tao Thursday, July 7, 2011 1:11 AM
Wednesday, June 29, 2011 9:38 AM

Answerer
0

Sign in to vote
Configure SQL agent to send emails: - http://support.microsoft.com/kb/908360

How to: Notify an Operator of Job Status (SQL Server Management Studio) : - http://msdn.microsoft.com/en-us/library/ms191130.aspx

Harsh Chawla Personal Blog:-http://blogs.msdn.com/batala Team Blog:- http://blogs.msdn.com/b/sqlserverfaq/
- Proposed as answer by Peja Tao Friday, July 1, 2011 5:32 AM
- Marked as answer by Peja Tao Thursday, July 7, 2011 1:11 AM
Wednesday, June 29, 2011 2:14 PM
1

Sign in to vote

Hi,

You can put the notification to send you an email to the desired operator "When the job completes".

So this will send you an email on both actions, whether it is a success or failure.

HTH,
Regards, Ashwin Menon My Blog - http:\\sqllearnings.wordpress.com

Thursday, June 30, 2011 2:55 AM