070-462 Job error log

Hi, I am preparing for 462 exam and have some practice questions with me, 

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?

choices are

1 ) Disable the Limit size of job history log feature.

2 ) Configure output files.

3 ) Expand agent logging to include information from all events.

4 ) Configure event forwarding.

according to me ans should be 2,

 but as per practice test ans is 3.

any help here to make me understand why.

any help will be appreciated.

August 27th, 2013 6:23pm

Hello,

Agree with you. 

If we want to do further analysis for the each steps in the job, we can try to specify the action to perform if the job step fails:On failure action list, specify the Output file where the job script output will be written.
Reference:http://technet.microsoft.com/en-us/library/ms177461.aspx

Regards,
Fanny Liu

If you have any feedback on our support, please click  here.

Free Windows Admin Tool Kit Click here and download it now
August 30th, 2013 5:08am

>3 ) Expand agent logging to include information from all events.

How do you carry it out exactly?

Following is the SS Agent error logging configuration.

This is the second place for log configuration.

September 4th, 2013 12:02am

So you suggesting 3 is the answer.
Free Windows Admin Tool Kit Click here and download it now
September 4th, 2013 3:43pm

Yes, 3 is the correct answer.

>1 ) Disable the Limit size of job history log feature.

Usually you increase it: 1000 lines for all jobs and 100 lines for 1 job the default.

2 ) Configure output files.

Since you are getting error log, file is already configured.

3 ) Expand agent logging to include information from all events.

Yes. See above. Correct choice.

4 ) Configure event forwarding.

This is an enterprise SS network feature to send error logs from remote server to central server.

September 4th, 2013 4:11pm

so what happened? what was the answer? pls help me

I am confused too

Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2014 5:36pm

https://www.mssqltips.com/sqlservertip/1411/verbose-sql-server-agent-logging/
July 15th, 2015 11:59pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics