SQL Server - Database Mail Newbie

Asked By Thomas R Grassi Jr

18-Nov-09 11:49 PM

SQL 2005 SP3 on Windows 2003 SP2 Server
Using the DB Maint Plan Wizard I setup a operator to send status reports to
my email account the Select Report Options screen is where you choose the
Email report option To (name)  I only have one profile setup in the database
mail

I have Database mail configured and I am able to send a test message to my
email account with no problem

Also I have the notifications of the job properties setup to send an email
when the job fails and that works also

Just can not figure out why the jobs are not sending a email when they are
successful

Also when you are using the Maint Plan wizard you can set the  Report
Options (email report to) question 2 is how to I see that information after
I save the new plan?

I tried to edit the properties etc can not find the option


As you can tell I am new to SQL2005 any help would be greatly appreciated

Thanks

Tom

20-Nov-09 11:23 AM

When you set up the notification for the job, there is also an option "When
the job completes". You may want to give that a try.

Linchi