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 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?

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



Leave a Reply 9

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


Eli

Eli

I’ve tested both (A) and (B), I got these results:
(B) Expand agent logging to include information from all events
This did put an entry in the SQL Server Agent Log advising that jobs were executing and completing but didn’t include any useful error details for a test job I ran which failed.
(A) Configure Output Files
This didn’t seem like it would be the best answer initially simply because it has to be done for every step in every job to answer the question which applies generally to ‘SQL Server Agent Jobs’, however it does log the details of each job step failure which is what we were after.
So the answer would appear to be (A) based on my testing.

Henry Figgins

Henry Figgins

I have to say, Shak and Eli, your comments are always money!

starter

starter

Same as Q15