SQL Server - SQL 2005 - Unwanted email notification when Maintenance Plan executes

Asked By Brian

05-Feb-08 12:45 AM

I'll start off by saying I'm pretty new to SQL Server 2005.  I created
a maintenance plan that simply backs up my databases.  It is scheduled
to run daily and works fine.  I have not set up any notifications (on
success or failure), but I get a message that says the job completed
successfully everytime it runs.  I only want a message when the job
fails though.  Here is the message I get when the job runs:

NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3054
Report was generated on "CLEGDW".
Maintenance Plan: Backup - System Databases
Duration: 00:00:05
Status: Succeeded.
Details:
Back Up Database (Full) (CLEGDW)
Backup Database on Local server connection
Databases: All system databases
Type: Full
Append existing
Task start: 2008-01-24T10:57:30.
Task end: 2008-01-24T10:57:35.
Success

24-Jan-08 01:11 PM

Go to Jobs on Management Studio, double click your job, and select
Notifications. Perhaps 'When the job completes' is selected. Change it to
'When the job fails'.

Since this job runs daily I would recommend to leave it as it is and receive
that e-mail daily. It could be the case that maybe the job is not running and
you are not receiving the e-mail either, for example, if the SQL Server Agent
is not running, there is a problem with the e-mail, etc.

Hope this helps,

Ben Nevarez

05-Feb-08 12:45 AM

Thanks for the response.  The only thing selected in Notifications is
to Write to the Windows Application event log.  Email is not selected
for notification, regardless of whether the job completes successfully
or not.  However, I still get the email when the job runs.  Seems so
simple, but I still can't figure it out.


On Jan 24, 1:11=A0pm, Ben Nevarez <BenNeva...@>
ve
and
ent

24-Jan-08 01:48 PM

Then you must have a Notify Operator Task in your maintenance plan. Open
your maintenance plan and review the available tasks.

If you still want to change the notification double click the arrow pointing
to this task to go to the Precedence Constraint Editor and change the Value
field to Failure.

Hope this helps,

Ben Nevarez

05-Feb-08 12:46 AM

Amazingly enough, the only task I have in the maintenance plan is a
Backup Database task.  It's about as trivial as a maintenance plan can
be.  I've been through every option I can think of, but still cannot
figure out why I get a successful email message.

Thanks again for your responses.


On Jan 24, 1:48=A0pm, Ben Nevarez <BenNeva...@>
ng
e

to
eceive
ing and
r Agent
ated
uled
(on

b

05-Feb-08 12:46 AM

Open the Maintenance plan in SSMS - there is a button to the right of
Manage Connections called 'Reporting and Logging'.  Open this dialog
and un-check the box 'Send report to an email recipient'.

05-Feb-08 12:47 AM

This worked perfectly.   Thank you for your help.



en
inting
Value
is
ted
ly
s so
m>

e it to
nd receive
running and
erver Agent
created
cheduled
ons (on
eted
e job
54
t -