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 are truncated.

The following error message is an example of the truncated error message:

-Executed as user CONTOSO\ServiceAccount….0.4035.00 for 64-bit Copyright (C) Microsoft

Corp 1984-2011. All rights reserveD. Started 63513 PM Error 2012-06-23 183536.87 Code 0XC001000E Source UserImport Description Code 0x00000000 Source Log Import Activity Descript… The package execution fA. .. The step failed. –

You need to ensure that a

ll the details of the job step failures are retained for SQL Server Agent jobs.

What should you do?

A. Expand agent logging to include information from all events.

B. Disable the Limit size of job history log feature.

C. Configure event forwarding.

D. Co

nfigure output files.

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 ste

ps 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 eve

nt forwarding.

Reference: