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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-06 : 08:59:36
|
| Rachna writes "I am using Sql Server 2000 on windows 2000 server (with SP) platform. I am confused in difference between SQL Mail and SQL Server Agent.Books on line say "SQL Mail establishes an extended MAPI connection with a mail host, while SQLAgentMail establishes an extended MAPI connection on its own". I don't understand this . Kindly explainRegardsRachna" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-05-07 : 01:22:41
|
| SQLMail, and SQLAgentMail (Which I assume is what you are refering to as opposed to just SQLAgent) are two different things.SQL Mail is used for procs such as xp_sendmail. SQLAgentMail is used to notify operators when an alert fires. There are other uses for each, but that is the easiest way to explain.Each will establish it's own MAPI session IF it is the only one running. However, if SQLMail is running and SQLAgentMail is started, SQLAgentMail will piggyback on the session started by SQLMail.-Chad |
 |
|
|
|
|
|
SQL Server Agent