Solved

Setting up notification for SQL maintenance jobs

Posted on 2012-03-17
1
199 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

691 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