XP_Startmail Errors in event log, why?

[lmorley]

Hi,
My mail services work fine but I get these errors
every time xp_startmail runs. IT is an informational
error.
Any reason why?

Error: 1073759806, Severity: 1, State: 0
Starting SQL Mail session...

Error: 1073759778, Severity: 1, State: 0
SQL Mail session started.

Thanks,
LAM2

 

[tlbroadbent]

It is not an error. It is an information message. Ignore it! Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[lmorley]

Is there any way to stop it from logging?
I run this every 10 min.
So the log file gets blasted.
THX

 

[tlbroadbent]

Why do you start mail every 10 minutes? Normal procedure is to start it when SQL Starts. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[lmorley]

More details.

SQL Mail is enabled with a profile.
The Agent starts on boot.

I have SP_Readmail that runs every 10 min
to get mail and place it into a table.
This is what generates the logs referenced before.

I think you helped me get this working some time ago

++++++CODE notes++++++++++++++++++
EXEC master.dbo.xp_startmail
XEC @status = master.dbo.xp_findnextmsg
@msg_id = @msgid OUTPUT,
@unread_only='true'
if @status <> 0
select @mapifailure=1
while (@mapifailure=0)
begin

(Then we)
EXEC @status = master.dbo.xp_readmail]
...
(Then we)
EXEC master.dbo.xp_stopmail.
+++++++++++

 

[tlbroadbent]

I don't see any need to run xp_startmail and xp_stopmail every time you run the procedure. We run a job that execute xp_stopmail and xp_startmail once each day, early in the morning. Stopping and starting the mail service daily seemed to help prevent problems but every 10 minutes seems like a waste to me. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[lmorley]

Thanks,
I'll geive that a try.
I assume that any SP that have
xp_startmail and xp_stopmail
should be removed then.

 

[tlbroadbent]

Yes, I'd remove them. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.