Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL2005 Mail Help

0 views
Skip to first unread message

Thomas R Grassi Jr

unread,
Nov 17, 2009, 5:57:16 AM11/17/09
to
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


Uri Dimant

unread,
Nov 17, 2009, 6:56:17 AM11/17/09
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

"Thomas R Grassi Jr" <thomas...@hotmail.com> wrote in message
news:O48h7S3Z...@TK2MSFTNGP02.phx.gbl...

Thomas R Grassi Jr

unread,
Nov 17, 2009, 10:38:29 PM11/17/09
to
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
"Uri Dimant" <ur...@iscar.co.il> wrote in message
news:%23BOWOz3...@TK2MSFTNGP04.phx.gbl...

Uri Dimant

unread,
Nov 18, 2009, 5:32:21 AM11/18/09
to

And did a restart? :-)

"Thomas R Grassi Jr" <thomas...@hotmail.com> wrote in message

news:%233caZCA...@TK2MSFTNGP05.phx.gbl...

Thomas R Grassi Jr

unread,
Nov 18, 2009, 6:27:34 AM11/18/09
to
restart what? sqlagent or the entire sql server

thanks tom


"Uri Dimant" <ur...@iscar.co.il> wrote in message

news:%23jlS1oD...@TK2MSFTNGP06.phx.gbl...

Uri Dimant

unread,
Nov 19, 2009, 4:06:31 AM11/19/09
to
At least Agent


"Thomas R Grassi Jr" <thomas...@hotmail.com> wrote in message

news:ukC$gIEaK...@TK2MSFTNGP06.phx.gbl...

Thomas R Grassi Jr

unread,
Nov 19, 2009, 10:18:40 PM11/19/09
to
Yes it is now working I restarted SQL 2005 all the services.

Thanks for your help

Tom

"Uri Dimant" <ur...@iscar.co.il> wrote in message

news:e2ZiidPa...@TK2MSFTNGP02.phx.gbl...

0 new messages