Microsoft
70-448 · Question #337
You are the administrator of a SQL Server 2008 instance. A SQL Server Agent job is failing. You find that the job history information is incomplete and seems to be truncated after you review it. All…
The correct answer is C. You should enable all job steps, making them send the output to a file. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. A SQL Server Agent job is failing. You find that the job history information is incomplete and seems to be truncated after you review it. All information produced by a job must be available for viewing. Which action should you perform to achieve this goal?
Options
- AYou should enable notifications to the Windows application event log when the job completes.
- BYou should enable write OEM file
- CYou should enable all job steps, making them send the output to a file
- DYou should include execution trace messages in the SQL Agent Error log
How the community answered
(28 responses)- A4% (1)
- B11% (3)
- C82% (23)
- D4% (1)
Community Discussion
No community discussion yet for this question.