SQL Server - SQL2005 Mail Help

Asked By Thomas R Grassi Jr

17-Nov-09 05:57 AM

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

17-Nov-09 06:56 AM

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

17-Nov-09 10:38 PM

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

18-Nov-09 05:32 AM

And  did a restart? :-)

18-Nov-09 06:27 AM

restart what?   sqlagent or the entire sql server

thanks tom

19-Nov-09 04:06 AM

At least Agent

19-Nov-09 10:18 PM

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

Thanks for your help

Tom