试题详情
单项选择题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A SQL Server Agent job is failing. You find that the job history information is incomplete and seems to be truncated after you review it. All information produced by a job must be available for viewing.  So what action should you perform to achieve this goal? () 

A、You should enable notifications to the Windows application event log when the job completes. 

B、You should enable write OEM file 

C、You should enable all job steps, making them send the output to a file 

D、You should include execution trace messages in the SQL Agent Error log

  • C
  • 关注下方微信公众号,在线模考后查看

热门试题