SQLMail & Outlook - Problems with attachments?

[eradtke]

Scenario:
I have one backup scheduled that always e-mails me when finished. This has never failed sending hte e-mail.

Later on in the night I have a report that is generated from a Oracle DB linked server. The DTS packaged runs find and sends the e-mail. The package has never failed but every damn time the e-mail is never sent. I always come in and stop/restart SQLAgent and the e-mail is sent.

Use MASTER
EXEC xp_sendmail @recipients = 'address here'
@subject = 'Trak-Star Posting Errors',
@attachments = 'c:\sqltemp\POSTING_ERRORS.xls',
@echo_error = 'TRUE'

EXEC xp_stopmail


this is a Execute SQL task that is using a connection set to Master DB as default. Anything you might recommend taking a look at? All applications are up to date with Service Packs.

 

[tlbroadbent]

You didn't mention the version SQL Server. If you use SQL 2000, remove xp_stopmail and xp_startmail from ALL scripts, queries, SPs, etc. that use it. Repeatedly starting and stopping SQLMail causes the problem you are encountering. I believe the problem occurs because of a memory leak. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[eradtke]

Will try. It's SQL2K