When I run this query it shows that sql is sending duplicate emails even up to 5 emails for same maintenance job that runs everyday.
select top 100 * from msdb..sysmail_sentitems s order by s.sent_date desc
Rerty option is set to zero
Any ideas why sql 2008 is sending duplicate emails for my jobs?
SQL 2008 Server 64 bit on Windows 2008 64 bit.