dbTalk Databases Forums  

Database Mail Newbie

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Database Mail Newbie in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Thomas R Grassi Jr
 
Posts: n/a

Default Database Mail Newbie - 11-18-2009 , 10: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

Reply With Quote
  #2  
Old   
Linchi Shea
 
Posts: n/a

Default RE: Database Mail Newbie - 11-20-2009 , 10: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

"Thomas R Grassi Jr" wrote:

Quote:
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


.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.