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
答案解析:有
微信扫一扫手机做题