mail without mapi

Hi All,
I've got a SQL cluster in its own domain that I need to get notifications
from when the maintenance jobs fail. If I can't use an outlook mapi client
to send mail how can I get notified that jobs fail? Someone said I could use
SMTP mail but I don't know how to do this. Please help.
TIA!!
jjUse xpsmtp from www.sqldev.net. I have used this in clustered environments
for a long time and have had zero problems.
Geoff N. Hiten
Microsoft SQL Server MVP
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:OcWeEBAeFHA.584@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I've got a SQL cluster in its own domain that I need to get notifications
> from when the maintenance jobs fail. If I can't use an outlook mapi client
> to send mail how can I get notified that jobs fail? Someone said I could
> use SMTP mail but I don't know how to do this. Please help.
> TIA!!
> jj
>

Mail Notifications Stop Working

We have some jobs that should e-mail the operator upon certain conditions. For reasons I cannot seem to find, the e-mail notifications have stopped coming (net sends do work). I can send mail from the SQL Agent service account from the desktop, but SQL won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't know where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K (SP3a) on a 4-processor Dell box.Do you have any warnings or errors in your SQL Server Agent
Error log - right click on SQL Server Agent in Enterprise
Manager and select Display Error Log.
Also - are you by any chance running in fiber mode?
-Sue
On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
<DaveK@.discussions.microsoft.com> wrote:
>We have some jobs that should e-mail the operator upon certain conditions. For reasons I cannot seem to find, the e-mail notifications have stopped coming (net sends do work). I can send mail from the SQL Agent service account from the desktop, but SQL won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't know where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K (SP3a) on a 4-processor Dell box.

Mail Notifications Stop Working

We have some jobs that should e-mail the operator upon certain conditions. For reasons I cannot seem to find, the e-mail notifications have stopped coming (net sends do work). I can send mail from the SQL Agent service account from the desktop, but SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't kno
w where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K (SP
3a) on a 4-processor Dell box.
Do you have any warnings or errors in your SQL Server Agent
Error log - right click on SQL Server Agent in Enterprise
Manager and select Display Error Log.
Also - are you by any chance running in fiber mode?
-Sue
On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
<DaveK@.discussions.microsoft.com> wrote:

>We have some jobs that should e-mail the operator upon certain conditions. For reasons I cannot seem to find, the e-mail notifications have stopped coming (net sends do work). I can send mail from the SQL Agent service account from the desktop, but SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't kn
ow where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K (S
P3a) on a 4-processor Dell box.
|||Not using fibers. The only messages in the agent error log are the normal informational ones that are found when restarting the agent, i.e., version, processors, memory, etc. It says the mail session was successfuly started.
"Sue Hoegemeier" wrote:
[vbcol=seagreen]
> Do you have any warnings or errors in your SQL Server Agent
> Error log - right click on SQL Server Agent in Enterprise
> Manager and select Display Error Log.
> Also - are you by any chance running in fiber mode?
> -Sue
> On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
> <DaveK@.discussions.microsoft.com> wrote:
QL won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't
know where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K
(SP3a) on a 4-processor Dell box.
>

Mail Notifications Stop Working

We have some jobs that should e-mail the operator upon certain conditions.
For reasons I cannot seem to find, the e-mail notifications have stopped com
ing (net sends do work). I can send mail from the SQL Agent service account
from the desktop, but SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, S
QL thinks the mail was sent OK, as it says "mail successfully sent". Howeve
r, the test mails never show up. Short of rebooting the server (a 24/7 prod
uction server), I don't kno
w where to go. Have checked the accounts, stopped and started the agent, et
c. If this is a clue, the agent also won't run some scheduled jobs. One da
ily job actually last ran two days ago, yet I don't see any errors or messag
es. Using Win2K, SQL2K (SP
3a) on a 4-processor Dell box.Do you have any warnings or errors in your SQL Server Agent
Error log - right click on SQL Server Agent in Enterprise
Manager and select Display Error Log.
Also - are you by any chance running in fiber mode?
-Sue
On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
<DaveK@.discussions.microsoft.com> wrote:

>We have some jobs that should e-mail the operator upon certain conditions. For rea
sons I cannot seem to find, the e-mail notifications have stopped coming (net sends
do work). I can send mail from the SQL Agent service account from the desktop, but
SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, S
QL thinks the mail was sent OK, as it says "mail successfully sent". Howeve
r, the test mails never show up. Short of rebooting the server (a 24/7 prod
uction server), I don't kn
ow where to go. Have checked the accounts, stopped and started the agent, e
tc. If this is a clue, the agent also won't run some scheduled jobs. One d
aily job actually last ran two days ago, yet I don't see any errors or messa
ges. Using Win2K, SQL2K (S
P3a) on a 4-processor Dell box.|||Not using fibers. The only messages in the agent error log are the normal i
nformational ones that are found when restarting the agent, i.e., version, p
rocessors, memory, etc. It says the mail session was successfuly started.
"Sue Hoegemeier" wrote:

> Do you have any warnings or errors in your SQL Server Agent
> Error log - right click on SQL Server Agent in Enterprise
> Manager and select Display Error Log.
> Also - are you by any chance running in fiber mode?
> -Sue
> On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
> <DaveK@.discussions.microsoft.com> wrote:
>
QL won't even send me a test mail from within SQL (using Ent. Mgr). However,
SQL thinks the mail was sent OK, as it says "mail successfully sent". How
ever, the test mails never show up. Short of rebooting the server (a 24/7 p
roduction server), I don't
know where to go. Have checked the accounts, stopped and started the agent,
etc. If this is a clue, the agent also won't run some scheduled jobs. One
daily job actually last ran two days ago, yet I don't see any errors or mes
sages. Using Win2K, SQL2K
(SP3a) on a 4-processor Dell box.[vbcol=seagreen]
>

Mail notifications for scheduled jobs

I have a sql server 2000 sp3a box with 4 named instances.

I have read all of the articles and I cannot get the 'send mail' stuff working.

I have a mailbox associated with the Domanin account that starts the sql server and sql server agent services. I installed Outlook and created a mail profile for this account. I bounced the SQL server agent on one of the Instances but when I go into the properties for the Agent, on the General Tab, the option to choose a mail profile is GREYED out. I tried 'xp_startmail' and I get this error: xp_startmail: failed with mail error 0x80040111

can anyone help???Are you logging on to the server as the account SQL runs under? You will need to be logged onto to the server with the service account in order to set the mail properties in the agent|||are you sure you have covered all of the basics. does the sql and sql agent services run under a network account that maps to the exchange account you are attempting to use?

have you attempted to use the outlook client installed on the db server.|||You've got about 9 months until maintstream support for SQL 2000 ends. Upgrade to SQL 2005 and use the Database Mail feature (a lightweight SMTP client, instead of the clunky MAPI compliant interface).

In case that is not an option, here are some MS KB articles on SQL 2000 and setting up mail profiles.

http://support.microsoft.com/kb/315886

http://support.microsoft.com/default.aspx/kb/281293

http://support.microsoft.com/kb/263556/EN-US/

Some CRITICAL things to remember:

1. Outlook is single-threaded; if it pops an error message at the console, it can and will lock up SQL's job system.

2. SQL Mail and SQL Agent mail do not have to use the same profile. However, you must set up each profile separately (ie, to use alerts you must set up SQL Agent Mail, to use xp_sendmail you must set up SQL Mail). The two features are set up in different places (SQL Agent mail is set up by right-clicking on SQL Agent and selecting properties; SQL Mail is set up under support services).

3. You will have to configure SQL Mail/SQL Agent Mail separately for each instance. You might want to consider a separate profile for each. Be careful of the overhead associated with running four MAPI client instances (plus for SQL instances) on the same server.

Having said all that, I don't really recommed using SQL Agent Mail or SQL mail on a production server. Like I said, upgrade to SQL 2005.

Regards,

hmscott