SQL2005 Mail Help

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

ThomasRight click on the SQL Server Agent Properties then navigate to

Thomas
Right click on the SQL Server Agent  Properties then navigate to Alert
System on the left pane

Configure mail session with your db mail profile

ThanksI checked that and I did have that setup correctly.

Thanks

I checked that and I did have that setup correctly.

I am still trying to figure out this

Any other ideas will be appreciated

Thanks

Tom

And did a restart? :-)

And  did a restart? :-)

restart what? sqlagent or the entire sql serverthanks tom

restart what?   sqlagent or the entire sql server

thanks tom

At least Agent

At least Agent

Yes it is now working I restarted SQL 2005 all the services.

Yes it is now working I restarted SQL 2005 all the services.

Thanks for your help

Tom