?
Solved

Setting up notification for SQL maintenance jobs

Posted on 2012-03-17
1
Medium Priority
?
202 Views
Last Modified: 2012-03-18
Hi

I have an exchange server and ad account ready to use for setting up email notifications for the SQL 2005 maintenance plans. I would like to be notified whether they pass or fail. Please can someone detail what steps I need to set this up?

Thanks
0
Comment
Question by:techno1981
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
techno1981 earned 0 total points
ID: 37734737
I've added database mail without any problem, tested the account and received an email at my hotmail address.

I've also added an operator with my email address to be notified when a maintenance job completes, but never receive an email. The job history just says email failed to send.

Any ideas what i've missed during the configuration?
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question