I have a stored procedure that executes sp_send_dbmail to a variety of recipients. It is scheduled to run at 4:00 AM and it successfully emails the text. However, it duplicates the email and sends it EXACTLY 1 minute later. The text in the email comes from a stored procedure but this stored procedure only runs a SELECT query (cursor).
Can someone help me figure out why this is duplicating the emails? We recently upgraded to MS Exchange 2010. I already looked at the advanced settings for the task and the retry attempts and retry interval are both set to zero (I seen that fixed the issue for someone else).
Thanks for the help.