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?
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.