I have a package that calls a stored procedure to send emails. Looking at the log after the job ran, there are a number of lines where it appears there was an error but there's no sign the email didn't get sent.
The SP should have sent over 3000 emails. In the SSIS log there are lots of OnError lines with Send Emails SP:Error: Mail (Id: nnnnn) queued as the message.
If I run the following query, it finds only 1 failed email task from the period in which all the SSIS error lines were generated.
select *
from Msdb.dbo.sysmail_faileditems
Are those errors I can ignore or is there somewhere other than that table where I can look for more details about the log error?