Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQLServerAgent Address book issue

Author  Topic 

steamngn
Constraint Violating Yak Guru

306 Posts

Posted - 2008-04-08 : 11:14:19
Anybody ever seen this?
SQL Mail is configured on SQL2K SP4 box w/ exchange 2003. Profile in Server and SQL Agent tests ok, and xp_sendmail works if the recipient field is in format 'whoever@company.com'.
xp_sendmail WILL NOT WORK if the recipient is in format 'Administrator';
error is 'recipient cannot be resolved'. Also, When adding an operator, there are no email addresses and no address lists to select if you browse for emails.
Any idea where I need to look?
TIA,
Andy

There's never enough time to type code right,
but always enough time for a hotfix...

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-08 : 22:44:00
It requires full address, and you have to type in email address for each operator.
Go to Top of Page
   

- Advertisement -