Last night the automated confirmation emails we have set up in our SSIS packages didn't arrive.
So we looked in
select top 50 *
order by send_request_date desc
But they weren't there - but then I took another look and found that none of the SSIS Emails have ever been logged there (although the emails have been received)
the question is where do SSIS email tasks get stored? - should they store in sysmail_allitems ?