You are using Database Mail to deliver email notification and are notified that an employee has not been receiving emails. You need to determine if any email notifications sent by Database Mail have…

The correct answer is D. msdb.dbo.sysmail_faileditems. sysmail_faileditems Contains one row for each Database Mail message with the failed status. Use this view to determine which messages were not successfully sent.

Troubleshoot and Optimize Databases

Question

You are using Database Mail to deliver email notification and are notified that an employee has not been receiving emails. You need to determine if any email notifications sent by Database Mail have been unsuccessful. Which object from the msdb database should you use?

Options

Amsdb.dbo.sysmail_event_log
Bmsdb.dbo.sysmail_sentitems
Cmsdb.dbo.sysmail_unsentitems
Dmsdb.dbo.sysmail_faileditems

How the community answered

(18 responses)

A
6% (1)
B
6% (1)
C
11% (2)
D
78% (14)

Explanation

sysmail_faileditems Contains one row for each Database Mail message with the failed status. Use this view to determine which messages were not successfully sent.

Topics

#Database Mail#sysmail_faileditems#msdb#email troubleshooting

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice