473,847 Members | 2,427 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server Agent + SQL Mail

Hi,
I've been able to successfully configure SQL Server Agent to send
notification emails to an appropriate Operator in the event of an alert
being fired. This all works fine on one condition - that Outlook client
is running on the server.

If Outlook is not running the alerts still be fired (i.e. the Occurance
Rate still increases as and when expected), but the emails being
generated will not be sent until the next time Outlook is opened.

Clearly it's unwise to rely on Outlook being open on the server at all
times, so I was wondering if anyone knows of a workaround to ensure
these emails are processed immediately?

I'm using SQL Server 2000 SP4 and Outlook 2003.

thanks,
Bob.

Jul 23 '05 #1
3 1512
Stu
Hi Bob,

SQLMail is one of my favorite things to hate about SQL Server; it's
difficult to trace why it doesn't work becuase so much of it has
nothing to do with SQL Server at all. Here's some of the things you
can check:

First, you must be running Exchange in order for it to work correctly.
In Outlook, under the Options, Mail Setup, verify that the Send
Immediately When Connected box is checked. Under the Send/Receive
option, you may have to schedule an automatic send/receive every few
minutes.

In essence, it sounds like an Outlook problem, not a SQL problem. You
may have to bring in an Exchange expert on this one.

Hope that helps, somehow.

Stu

Jul 23 '05 #2
Hi thanks for the response.

That was the sort of reply I was hoping for, though I don't have the
means to check the exchange server for such setting so I'll have to get
someone else to check it out.

All the best.
Bob.

Stu wrote:
Hi Bob,

SQLMail is one of my favorite things to hate about SQL Server; it's
difficult to trace why it doesn't work becuase so much of it has
nothing to do with SQL Server at all. Here's some of the things you
can check:

First, you must be running Exchange in order for it to work correctly.
In Outlook, under the Options, Mail Setup, verify that the Send
Immediately When Connected box is checked. Under the Send/Receive
option, you may have to schedule an automatic send/receive every few
minutes.

In essence, it sounds like an Outlook problem, not a SQL problem. You
may have to bring in an Exchange expert on this one.

Hope that helps, somehow.

Stu


Jul 23 '05 #3

"Stu" <st************ **@gmail.com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com...
Hi Bob,

SQLMail is one of my favorite things to hate about SQL Server; it's
difficult to trace why it doesn't work becuase so much of it has
nothing to do with SQL Server at all. Here's some of the things you
can check:

First, you must be running Exchange in order for it to work correctly.
This is not true. This keeps getting repeated, but is inaccurate.

It is true that Outlook has to be setup in Corporate/Workgroup mode however.
My suggestion (among others) if you're NOT using Exchange is to install an
SMTP server directly on the SQL Box and lock it down so only that box can
send mail through it.

Setup Outlook 2000 (I don't believe 2003 will work at all) to send through
that SMTP server. This eliminates a whole class of problems where the
MAPI32SP.DLL can get wedged if it loses contact with the SMTP server.

After that, there's a KB article on MS's site about how to properly config
Outlook. Follow ALL of it.

Some other advice:
Make sure ALL the mailboxes (including SENT, OUTGOING, etc.) are empty. No
idea why this makes a difference, but it helps.

Also, make sure you can send it from the account SQLAadmin and SQL Server
are running under. (i.e. log in as that user and send an email.)

Then log out.

THEN start up SQLSERVERAGENT.

I will agree with Stue, it's one of the things I really dislike about SQL
Server.

However, I've found that with moving the SMTP server locally, I've had zero
problems once I got it working. That alone has made a huge difference in my
stability.
In Outlook, under the Options, Mail Setup, verify that the Send
Immediately When Connected box is checked. Under the Send/Receive
option, you may have to schedule an automatic send/receive every few
minutes.

In essence, it sounds like an Outlook problem, not a SQL problem. You
may have to bring in an Exchange expert on this one.
I'd disagree. I've seen exactly this behaviour and it appears to have to do
with how SQL Server accesses the config via MAPISP32.DLL.


Hope that helps, somehow.

Stu

Jul 23 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

21
3395
by: Nancy | last post by:
Hi, Guys, Is there any other way to use python or mod_python writing a web page? I mean, not use "form.py/email", no SMTP server. <form action="form.py/email" method="POST"> ... Thanks a lot. Nancy W
0
1223
by: Sean Lambert | last post by:
I'm trying to setup SQLMail on a SQL Server. The same server has an application running on it, which successfully uses Outlook as a mail client. I have setup a Mail Profile under Outlook for the current login, which is the same login that the SQL Agent is running under. After going through the SQLMail setup, when I go to the SQL Server Agent Properties, I'm not able to select a mail profile (there is no drop-down list). The only...
0
1241
by: Philip Bondi | last post by:
Hello to all: Under Enterprise Manager, select server, select management, right-click on sql server agent. On the general tab, observe the mail session. Using SQL-DMO, how can I find the mail profile? I've combed the help file and the net without any luck.
1
1715
by: dananrg | last post by:
I would like to configure e-mail alerts on my SQL Server 2000 box. However, we also run Exchange on the same machine. I've been told there could be conflicts/issues having Outlook on the same machine as Exchange; and apparently, one needs Outlook to configure a mail profile for SQL Server Agent. Is there, in fact, anything to worry about? If so, are there any work-arounds beside moving Exchange to another server? (we've only got one...
1
5108
by: brianhensley | last post by:
It's a Windows 2000 Server box with SQL 2000 on it. MSSQLSERVER & SQLSERVERAGENT services are logged in as valid domain user. I set up a mail profile for that user, and can send email via Outlook 2003. However, when I go to the SQL Agent Properties in Enterprise Manager, Mail Profile is disabled. I've restarted the services & even tried rebooting the server. This works on my other servers, but they're Windows 2003. Not sure if...
2
3154
by: Eric Timely | last post by:
After a trust with exchange server established the xp_SendMail gives the following error: xp_sendmail: failed with mail error 0x80070005 Prior to the trust everything worked fine. I have tried the following: 1)Checking SQL and SQLAgents accounts all match up with default mail profile.
1
1817
by: Viktor Popov | last post by:
Hi, is it possible MS SQL Server Agent to make a WebApplication in ASP.NET/C# to send e-mail using MailMessage class? If yes, how? Thank you! Viktor
42
3548
by: scorpion53061 | last post by:
Is there a registry setting that I can read in vb.net for windows platforms that will give me the default mail server for the computer (e.g. mail.charter.net)
0
2356
by: aj | last post by:
SQL Server 2005 SP2 64-bit I am quite confused about the SQL Server Agent Alert System. I have configured Database Mail, establishing my Profile(s) and Account(s), and specifying SMTP server+port. I then configured SQL Server Agent, under Properties->Alert System, to use Database Mail, specifying a particular Mail Profile to use. I then go into the properties of one of my Agent Jobs, and under
3
3605
by: graphicssl | last post by:
Okay, so first of all, I'm a designer first and a light coder second (I'm only really trained with HTML and CSS). So I apologize for having to post about something that's probably super-trivial! I'm working on setting up a shopping cart for a one-product web site, and I'm using HTML and CSS, with ASP for the shopping cart. The ASP takes the information from the form on the shopping cart, and formats it in to two e-mails: one for the company...
0
9727
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10981
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10330
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9477
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7879
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5716
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4521
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4113
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3158
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.