database mail keeps stopping...

[light_wt]

Hi,

I have several SQL05 enterprise 64 on a win 2003 ent 64bit.

there is one that's been a problem child.

i script out the database mail setup from the other server and tried
executed in this box, it fails.

basically, the status of sysmail will go stop or queue will go inactive.

if I do a
sysmail_start_sp
then
EXEC msdb.dbo.sysmail_help_status_sp
will show Status of STOPPED
so, i do again
sysmail_start_sp
and it is started.

if I do
EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail'
will show state of INACTIVE
queue_type length state last_empty_rowset_time last_activated_time
---------- ----------- -------- -----------------------
-----------------------
mail 4 INACTIVE 2009-04-22 16:24:26.330 2009-04-22
16:26:11.330
so, i
EXEC msdb.dbo.sysmail_start_sp
then
status will be RECEIVES_OCCURRING
but, as soon as i try to send a test email, status goes STOP again.