dbTalk Databases Forums  

Using SQL Mail in a cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Using SQL Mail in a cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Calvin Do
 
Posts: n/a

Default Using SQL Mail in a cluster - 02-22-2005 , 05:46 PM






Hello,

I'm trying to set up alerts for jobs and backups, using sql mail. Will this
work in a clustered enviroment? if so, can you please forward some
information on how to get this set up?


thanks in advace.


Calvin



Reply With Quote
  #2  
Old   
Mike Epprecht (SQL MVP)
 
Posts: n/a

Default RE: Using SQL Mail in a cluster - 02-23-2005 , 03:11 AM






Hi

It is not fully supported, but works in most cases.

From my experience, aleerts and job failures work OK, but DTS packages
sending mail do not.

Have a look at http://support.microsoft.com/kb/298723/EN-US/ and look up the
topics in BOL that it mentions.

Regards
Mike

"Calvin Do" wrote:

Quote:
Hello,

I'm trying to set up alerts for jobs and backups, using sql mail. Will this
work in a clustered enviroment? if so, can you please forward some
information on how to get this set up?


thanks in advace.


Calvin




Reply With Quote
  #3  
Old   
Chris Wood
 
Posts: n/a

Default Re: Using SQL Mail in a cluster - 02-23-2005 , 09:20 AM



Calvin,

We installed the Outlook Client on both nodes of our W2K3 cluster SQL2000
cluster and it is working.

Chris Wood

"Calvin Do" <calvin (AT) spinsonic (DOT) com> wrote

Quote:
Hello,

I'm trying to set up alerts for jobs and backups, using sql mail. Will
this
work in a clustered enviroment? if so, can you please forward some
information on how to get this set up?


thanks in advace.


Calvin





Reply With Quote
  #4  
Old   
Calvin Do
 
Posts: n/a

Default Re: Using SQL Mail in a cluster - 02-23-2005 , 05:09 PM



thanks for your responses... i'll give it a shot.




"Calvin Do" <calvin (AT) spinsonic (DOT) com> wrote

Quote:
Hello,

I'm trying to set up alerts for jobs and backups, using sql mail. Will
this
work in a clustered enviroment? if so, can you please forward some
information on how to get this set up?


thanks in advace.


Calvin





Reply With Quote
  #5  
Old   
Greg D. Moore \(Strider\)
 
Posts: n/a

Default Re: Using SQL Mail in a cluster - 03-01-2005 , 10:34 PM




"Calvin Do" <calvin (AT) spinsonic (DOT) com> wrote

Quote:
Hello,

I'm trying to set up alerts for jobs and backups, using sql mail. Will
this
work in a clustered enviroment? if so, can you please forward some
information on how to get this set up?

As others have said, works, but not supported.

Set up both EXACTLY the same way.


Quote:
thanks in advace.


Calvin





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.