Microsoft
70-432 · Question #181
You maintain a SQL Server 2008 instance. You use SQL Server Database Mail to distribute multiple reports that are scheduled and generated every night. You need to enforce a mail retention policy to…
The correct answer is D. Create a SQL Agent job to use the sysmail_delete_mailitems_sp stored procedure to delete. See the full explanation below for the reasoning.
Question
You maintain a SQL Server 2008 instance. You use SQL Server Database Mail to distribute multiple reports that are scheduled and generated every night. You need to enforce a mail retention policy to delete copies of automatically generated mails after 60 days. Which process should you use?
Options
- ASet the Subscription retention interval to delete mails after 60 days.
- BSet the MailProfile property of a Management Policy on the Server facet to delete mails
- CCreate a SQL Agent job to use the sysmail_delete_log_sp stored procedure to delete mails
- DCreate a SQL Agent job to use the sysmail_delete_mailitems_sp stored procedure to delete
How the community answered
(16 responses)- A6% (1)
- B13% (2)
- D81% (13)
Community Discussion
No community discussion yet for this question.