You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. One morning you are being bugged by your boss. Apparently there are problems with
the SQL Server Agent Service and the SQL Server Agent job.
What steps should you take to obtain more information regarding this problem?
A.
You should consider checking the TRANSACTION log.
B.
Check the SQL Book Online.
C.
You should consider checking the SQLAGENT.OUT log.
D.
You should consider checking the ERRORLOG log.
E.
You should consider checking the VIEWDELETE log.
F.
You should consider checking the SQLSERVER log.
Explanation:
The SQLAGENT.OUT file is an errorlog file for the SQL server Agent service. It would contain
information regarding the problem in this scenario.