PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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

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

  2. Eli says:

    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.




    0



    0

Leave a Reply