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. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E:drive. The job logs information to the text file. You get a report from users saying that the server doesn';t make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn';t function any loner. As the IT support, you have to identify the reason for the failure of the SQL Server Agent service. Which log should you check? ()
- AYou should check ERRORLOG
- BYou should check QL1.log
- CYou should check SQLAGENT.OUT
- DYou should check log_xx.trc