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?
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.
Explanation:
http://msdn.microsoft.com/en-us/library/ms175488.aspx
A
A is the correct answer
Its not A. You need output file when you cant read the entire log. This one is not providing any information.
its B.
if u use output file, you will have same msg in file. you need to expand agent logging, so u can get more info about errors.
A, checked
B, checked
Because the question explicitly requires that all details of job step failures are to be retained I would go for A.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7ad3f1ef-d49b-4741-af3f-85fd9cc780b2/demo-question?forum=sqldatabaseengine