Microsoft
70-457 · Question #147
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 correct answer is A. Configure output files. See the full explanation below for the reasoning.
Question
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?
Options
- AConfigure output files.
- BExpand agent logging to include information from all events.
- CDisable the Limit size of job history log feature.
- DConfigure event forwarding.
How the community answered
(55 responses)- A75% (41)
- B4% (2)
- C9% (5)
- D13% (7)
Community Discussion
No community discussion yet for this question.