SQL Mail doesn't work but SQLAgentMail works on prod server

SQL Mail doesn't work but SQLAgentMail works on prod server

Post by Maggi » Wed, 12 Mar 2003 02:26:07

SQL Mail doesn't work but SQLAgentMail works on our PROD
SQL Server

As far as we know,  via SQLAgentMail,   we can sends e-
mail and electronic pager notifications to designated
users in response to the triggering of an alert or the
success or failure of a job.

However, via SQL Mail,  we tried to use the xp_sendmail
extended stored procedure to send e-mail from Transact-SQL
batches, scripts, stored procedures, and triggers.  It
apparently doesn't work at all.
For instance, we have run the following notification:

This process  ran forever untill we stopped it.  But there
was still runnable process in the system as like "EXECUTE
master.dbo.xp_get_mapi_profiles"  run forever as garbage
process.  It can not be killed or cleaned up until we
stopped the services.  

Our PROD server platform:  W2k Advanced Server with sp2,  
SQL 2K with sp2.  

The strange thing is we have another DEV server with same
configuration ( only difference is DEV server with SP3)
can perform both SQL MAIL and SQL Agent Mail.  

Please help.


SQL Mail doesn't work but SQLAgentMail works on prod server

Post by Yih-Yoon Lee [M » Wed, 12 Mar 2003 08:13:06


Have you reviewed this article and follow the steps to setup SQL Mail yet?

INF: How to Configure SQL Mail         ID: 263556.KB.EN-US

Yih-Yoon Lee
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.


1. Query works in SQL Query Analyzer but doesn't work in DTS

I am trying to insert records to a table in a database if the records are not existed in the table already. The source data is from a table in another database.  My query runs fine when I test it in Query Analyzer but it doen't seem working in DTS package. I setup a job to run a DTS package nightly. The job runs no error. But it doesn't insert the records. Any thougts and suggestions are greatly appreciated.  ---YH

Here is the my query:

INSERT INTO [db1]..[Members_]
   (UserID_, Domain_, EmailAddr_, FullName_, List_, UserNameLC_)

SELECT Distinct

FROM [db2]..[mgt505-01], [db1]..[Members_]
     WHERE ([db2]..[mgt505-01].[Email]
        NOT IN
                (SELECT [db1]..[Members_].[EmailAddr_]
                FROM [db1]..[Members_]
                WHERE [db1]..[Members_].[List_] = 'mgt505-01')
                 And [db1]..[Members_].[list_] = 'mgt505-01')

2. newbie: selecting from another select...


4. many to many relation

5. SQL Mail doesn't work...

6. NULL values and indexing

7. SQL Mail doesn't work after SP2

8. Truncating text type parameter in ADO

9. SQL Mail with query parameter doesn't work

10. SQL Mail doesn't work after ugrading to SQL2K

11. sql enterprise manger's rigester server doesn't work in a nt workstation

12. Registering server doesn't work with SQL Server 7.0

13. Trigger works but doesn't work