You use RDS stored procedures to view messages, event logs, and attachments.
To view all email messages
-
Use the following SQL query.
SELECT * FROM msdb.dbo.rds_fn_sysmail_allitems(); --WHERE sent_status='sent' or 'failed' or 'unsent'
To view all email event logs
-
Use the following SQL query.
SELECT * FROM msdb.dbo.rds_fn_sysmail_event_log();
To view all email attachments
-
Use the following SQL query.
SELECT * FROM msdb.dbo.rds_fn_sysmail_mailattachments();
