I have three maintenance plans:
1. Application DBs - 2am (checks integrity, full backup, log backup)
2. System DBs - 3am (checks integrity, updates statistics, full backup)
3. Backup and log file cleanup - 3:30am (removes backup history, .bak and .trn files)
For items 1 and 3 above, I see the database mail process start up and receive emails that the jobs completed. For item 2, no email....the database mail process does not start and there are no errors in the event log. The job history shows that
the job completed successfully.
I'm having the same problem on a different server, except that items 2 and 3 email me their results, but item 1 does not. Same exact job steps and times of execution. None of the jobs are set to notify the operator, the notification is coming
from the maintenance plan.
Obviously I've gone through the basics:
Configured an operator
Created a default, public profile
Enabled mail profile in SQL Server agent
Tested mail delivery
How do I diagnose the database mail process just not starting? Has anyone seen this before?