"Cata" <anonymous@discussions.microsoft.com> wrote in message
news:366901c3e1f1$792a9e70$a601280a@phx.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
> >
> >
> >.
> >

Cata wrote:
> Hi,
>
> I am new with the SQL Server clustering, what do you
> recommend for jobs notification?

>-----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@discussions.microsoft.com> wrote in
message
>news:366901c3e1f1$792a9e70$a601280a@phx.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
>> >
>> >
>> >.
>> >
>
>
>.