The following messages appear in your database mail log file every 10 minutes.
“DatabaseMail process is started”
“DatabaseMail process is shutting down”
Database Mail is set to shut down every 10 minutes by default and restart when emails are sent. On a busy server you might want to change this as follows.
Go to SSMS object browser, right click on the Database Mail icon, choose “view of change system parameters”, set new value in “Database Mail Executable Minimum Lifetime (seconds)”. Here’s how to calculate a value for 12 hours.
-- 60 seconds (as 1 minute) * 60 minutes (as 1 hour) * 12 hours SELECT 60*60*12 AS ServiceUpTime ServiceUpTime ------------- 43200
