sql mail and sql agent mail

sql mail and sql agent mail

Post by Maria Garci » Tue, 15 Apr 2003 21:30:32

I have a job that run send mail using sql agent mail and
sql mail. Unfortunately, sql mail and sql agent mail fail
to send a message intermitently (sometimes it sends it and
sometimes it does not) but I do not get an error message
anywhere. The only thing I get is in the windows
application log that the job failed but no error number. I
do not get any errors in the sql agent log or sql server
error log. If you have any suggestions in how to trace
this, please let me know. Thank you in advance!!!

1. SQL Mail vs SQL Agent Mail

SQL Mail is used by the SQL Server service - configured from
Enterprise Manager under Support Services. It's used when
you do things like xp_sendmail.
SQL Agent Mail is used by the SQL Server Agent service -
configured from the properties of SQL Server Agent. It's
used for sending out email job failure notifications, alert
email notifications.  


On Thu, 14 Mar 2002 17:30:37 -0800, "yuling"

2. Book for Sybase programmers?

3. Setting up SQL Agent Mail and SQL Mail

4. Need Help Moving To Another Platform

5. Problem in Setting SQL Mail / SQL Agent Mail

6. Datarepeater checkbox help ...

7. SQL server 7 agent mail / SQL mail setup questions

8. virtual tables

9. Lotus Notes and SQL Mail/SQL Agent Mail

10. SQL Agent Mail and SQL Mail

11. SQL Mail and Agent Mail with Lotus Notes

12. SQL agent mail vs XP_SEND MAIL

13. Send E-Mail Without Using SQL Mail in SQL Server (Q312839)