You need to ensure that all available details of the job step failures for SQL Server Agent jobs are retained

You administer a Microsoft SQL Server 2012 instancethat has several SQL Server Agent jobs configured.
When SQL Server Agent jobs fail, the error messagesreturned 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?

You administer a Microsoft SQL Server 2012 instancethat has several SQL Server Agent jobs configured.
When SQL Server Agent jobs fail, the error messagesreturned 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:
Reference: http://msdn.microsoft.com/en-us/library/ms175488.aspx



Leave a Reply 7

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


Tester

Tester

Testee is correct. Should be Answer A

jzed

jzed

what is the correct answer?

Vivek Singh

Vivek Singh

A – is the answer. Using SSMS configure the output file.

Z

Z

Answer B is right.

When the question is about truncated message, choose A

When the question is about all available details, choose B

starter

starter

Same as Q27.