 | |
email notification from the clustered SQL Servers
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
email notification from the clustered SQL Servers -
01-23-2004
, 01:18 PM
#2
| |||
| |||
|
|
Hi, I am new with the SQL Server clustering, what do you recommend for jobs notification? |
http://support.microsoft.com/default...b;en-us;298723
Otherwise you should use a custom stored procedure that use the SMTP service
http://www.sqldev.net/xp/xpsmtp.htm
Bye
--
Luca Bianchi
Microsoft MVP - SQL Server
http://mvp.support.microsoft.com
http://italy.mvps.org
#3
| |||
| |||
|
|
-----Original Message----- Cata wrote: Hi, I am new with the SQL Server clustering, what do you recommend for jobs notification? You can setup an identical MAPI profile on each nodes of your cluster http://support.microsoft.com/default.aspx?scid=kb;en- us;298723 Otherwise you should use a custom stored procedure that use the SMTP service http://www.sqldev.net/xp/xpsmtp.htm Bye -- Luca Bianchi Microsoft MVP - SQL Server http://mvp.support.microsoft.com http://italy.mvps.org . |
#4
| |||
| |||
|
|
How can I use xp_smtp_sendmail to send job notifications? -----Original Message----- Cata wrote: Hi, I am new with the SQL Server clustering, what do you recommend for jobs notification? You can setup an identical MAPI profile on each nodes of your cluster http://support.microsoft.com/default.aspx?scid=kb;en- us;298723 Otherwise you should use a custom stored procedure that use the SMTP service http://www.sqldev.net/xp/xpsmtp.htm Bye -- Luca Bianchi Microsoft MVP - SQL Server http://mvp.support.microsoft.com http://italy.mvps.org . |
#5
| |||
| |||
|
|
-----Original Message----- Add an ON SUCCESS step and an ON FAIL step to each job with a different email message for each. Slightly cumbersome, but once you have one working, you can use it as a template to script others. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator CareerBuilder.com "Cata" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:366901c3e1f1$792a9e70$a601280a (AT) phx (DOT) gbl... How can I use xp_smtp_sendmail to send job notifications? -----Original Message----- Cata wrote: Hi, I am new with the SQL Server clustering, what do you recommend for jobs notification? You can setup an identical MAPI profile on each nodes of your cluster http://support.microsoft.com/default.aspx?scid=kb;en- us;298723 Otherwise you should use a custom stored procedure that use the SMTP service http://www.sqldev.net/xp/xpsmtp.htm Bye -- Luca Bianchi Microsoft MVP - SQL Server http://mvp.support.microsoft.com http://italy.mvps.org . . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.