Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance for a Server Agent job.
During routine monitoring, you notice that the Server Agent job is not running as it should be.
Upon further analysis of the job history data, you find that it is unfinished and condensed.
You have to make sure that job data is accessible in its entirety.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance for a Server Agent job.
During routine monitoring, you notice that the Server Agent job is not running as it should be.
Upon further analysis of the job history data, you find that it is unfinished and condensed.
You have to make sure that job data is accessible in its entirety.
Which of the following actions should you take?

A.
You should consider having trace logging enabled.

B.
You should consider configuring the job step options to allow job steps to be sent to an output
file.

C.
You should consider having event logging enabled.

D.
You should consider running the perfmon.exe command

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *