adding operator to sql server 2000

I need to add an operator to sql server 2000, but for some reason, the email
isn't getting sent out to them.
I have them configured the same as me, and have sent them email several
times, but they haven't received it. I even added my email address to the
"name" in there, and I haven't gotten email addressed to them, but my email
as another operator seems to work fine.
Is there a log of email that is accumulated on sql server's logfiles or
something that you can tell if it's left the server yet?
Any help appreciated.
Thanks,
SCtry xp_sendmail in Query Analyzer. It will show errors on failure.
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
email
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
email
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>|||This seems to work fine.
However, when I go to the Operators menu on the tree for the server, and put
in an email address to send it to & then click test, it says it sends it.
However, neither of us are receiving it.
On another operator tab, it'll do the same thing. It had been sending me an
email when a job completed.
SC
"Richard Ding" <rding@.acadian-asset.com> wrote in message
news:e7K$LVxeEHA.3632@.TK2MSFTNGP09.phx.gbl...
> try xp_sendmail in Query Analyzer. It will show errors on failure.
>
> "Goober at christianDOTnet" <me@.privacy.net> wrote in message
> news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> email
the[vbcol=seagreen]
> email
>|||If it is working for some operators, but not others.
1. Try sending an email to the failed email address directly ( outside SQL )
to make sure the email is working.
2. drop the operator and re-add the operator in SQL Agent, Be sure to use
the entire email address.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
email
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
email
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>