PrepAway - Latest Free Exam Questions & Answers

Which process should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Set the Subscription retention interval to delete mails after 60 days.

B.
Set the MailProfile property of a Management Policy on the Server facet to delete mails
after 60 days.

C.
Create a SQL Agent job to use the sysmail_delete_log_sp stored procedure to delete
mails older than 60 days.

D.
Create a SQL Agent job to use the sysmail_delete_mailitems_sp stored procedure to
delete mails older than 60 days.


Leave a Reply