Re: How to email on job failures?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chris V. (tophe_news_at_hotmail.com)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 16:21:00 +0100

Brett,

SMTP can't be use without SQL on it's own. If you wnt to use the bilt-in
mail function in SQL, you have to use MAPI.
However, as Aaron mention, you can use SMTP throug third part product.

Chris
"Brett" <no@spam.com> wrote in message
news:uXxmygn7EHA.128@TK2MSFTNGP15.phx.gbl...
> My mail is POP. Will that still work? Are most POP accounts also MAPI?
>
> Thanks,
> Brett
> "Chris V." <tophe_news@hotmail.com> wrote in message
> news:%23tTT5sk7EHA.3644@TK2MSFTNGP09.phx.gbl...
> > Hi Brett,
> >
> > SQL server relies on MAPI.
> > To be able to use it you ahve to :
> > Create the MAPI profile when logged on as the acccount used to run
the
> > SQL Service Agent
> >
> > Setup the profile in to Enterprise Manager.
> >
> > -> You have to restart the SQL Service Agent to have the modification
> > taken
> > in consideration.
> >
> > Chris
> >
> > "Brett" <no@spam.com> wrote in message
> > news:uPm70gf7EHA.1392@tk2msftngp13.phx.gbl...
> >> I'd like SQL Server to email me on job failures. I've setup a profile
> >> through the mail icon in control panel and tested it successfully.
When
> >> I
> >> go to the Operators area under SQL Server Agent and click the "Test"
> > button
> >> for "E-Mail name:", I get this error:
> >>
> >> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not
> >> running; check the mail profile and/or the SQLServerAgent service
startup
> >> account in the SQLServerAgent Properties dialog.
> >>
> >> I've also tried:
> >>
> >> use master
> >> EXEC xp_startmail
> >>
> >> but get this error:
> >> Server: Msg 17985, Level 16, State 1, Line 0
> >> xp_startmail: Procedure expects parameter @user, which was not
supplied.
> >>
> >> From the documentation for Operators, it seems there is a way to set
this
> > up
> >> completely through EM and avoid any SPs. Any suggestions?
> >>
> >> Thanks,
> >> Brett
> >>
> >>
> >
> >
>
>

Quantcast