You need to ensure that all information produced by a job is available for viewing

You maintain a SQL Server 2008 instance.
You find a SQL Server Agent job is failing. When you review the job history information, you
notice that the job history information is incomplete and appears to be truncated.
You need to ensure that all information produced by a job is available for viewing.
What should you do?

You maintain a SQL Server 2008 instance.
You find a SQL Server Agent job is failing. When you review the job history information, you
notice that the job history information is incomplete and appears to be truncated.
You need to ensure that all information produced by a job is available for viewing.
What should you do?

A.
Enable write OEM file.

B.
Enable all job steps to send the output to a file.

C.
Include execution trace messages in the SQL Agent Error log.

D.
Enable notifications to the Windows application event log when the job completes.



Leave a Reply 0

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