Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Where are emails sent from SSIS Packages stored? Expand / Collapse
Author
Message
Posted Thursday, June 18, 2009 4:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 15, 2012 6:08 AM
Points: 2, Visits: 18
Last night the automated confirmation emails we have set up in our SSIS packages didn't arrive.

So we looked in

select top 50 *
from msdb..sysmail_allitems
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 ?
Post #737364
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse