Provisioning SQL Databases — Question 24

You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured.
When SQL Server Agent jobs fail, the error messages returned by the job steps do not provide the required detail.
The following error message is an example error message:
"The job failed. The Job was invoked by User CONTOSO\ServiceAccount. The last step to run was step 1 (Subplan_1)."
You need to ensure that all available details of the job step failures for SQL Server Agent jobs are retained.
What should you do?

Answer options

• A. Configure output files.
• B. Expand agent logging to include information from all events.
• C. Disable the Limit size of job history log feature.
• D. Configure event forwarding.

Correct answer: B

Explanation

Option B is correct because expanding agent logging will capture more detailed information about job step failures, which is necessary for troubleshooting. Option A, configuring output files, may help but does not address logging comprehensively. Option C, disabling the job history log size limit, does not directly increase the detail of error messages. Option D, configuring event forwarding, is unrelated to capturing detailed job step failure messages.