You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance.
You have previously devised a maintenance strategy that allows for the reconstruction of indexes,
as well as database integrity verification. The strategy is also configured to generate reports in the
form of a text file.
You have now been instructed to configure the strategy to forward e-mails to ABC.com operators
whenever the strategy is unsuccessfully implemented.
Which of the following actions should you take?
A.
You should consider altering the Event log.
B.
You should consider altering the SQL Active Directory Helper.
C.
You should consider altering the SQL Server Agent job.
D.
You should consider altering the SQL Server Browser.
Explanation: