Hi,
Just wanted to point out that 43200 is 12 hrs not 24 hours; in case it has not been pointed out.
raul.pino (2/3/2011)
In the object explorer, go to ...Management>>
>>Database Email (right click)
>>>>Click on "Configure Database Mail".
>>>>>>Select "View or change system parameters"
>>>>>>>>The "Database Mail Executable Lifetime (seconds)" is set at 600 seconds by default.
(600 seconds / 60 second in a minute = 10 minutes)
If you look at the Database Mail logs, you can see the service shuts down after ten minutes. I set this value at 43200 seconds which is equivalent to 24 hours.
After changing this, I have never had another problem.
To start the database mail after you have changed the settings, just send a test email by right-clicking on Database Email in the Management tab. When the test email is sent, it will auto-start the service. Keep on eye on the log for after ten minutes to ensure the service does not shut down again.