You administer a SQL Server 2008 instance. You configure a single Database Mail profile
that is used to send reports to all the employees of your organization. The sp_send_dbmail
stored procedure is used to send a large volume of reports during business hours. The
reports to the manager take a long time to be delivered.
You need to ensure that the reports to the manager are sent as quickly as possible.
What should you do?
A.
Add another SMTP account to the existing Database Mail profile.
B.
Configure a new Database Mail profile to be used for the reports to the manager.
C.
Use the (©importance = high parameter when you send the reports to the manager.
D.
Change the Account Retry Attempts option of the Database Mail system properties.