SQL 2005 Database Mail - Attachments Saved

[EriRobert]

Hi
We recently started to use Database Mail to send information packs to our clients (pdf attachments). The emails + attachments are sent without a problem. I have subsequently noticed that the attachments are being saved on the C drive causing space issues - for example:

C:\Documents and Settings\ADPH\Local Settings\Temp\1a33ff6a-63b4-4bc4-b0e7-7efe9e6f98d0\Info.pdf


Is this normal behaviour? Is there a setting to persuade database mail to tidy up (delete these files) after sending?

Thanks

 

[ptheriault]

You will have to create a maint plan to go clean up that directory.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[EriRobert]

Thanks Paul

Yes I can do that.

Why does Database mail leave them in the first place? For example, we don't expect to clean up Tempdb after it has run some queries. Is there a reason why they are allowed to build up?

Curious really

Many Thanks

Robert