What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
Domain.com contains a SQL Agent job that runs every 5 minutes.
Domain.com also has a text file called CK_Tst.log on F: drive that logs all the information of the job.
One morning during monitoring you notice the following:
* The SQL Server Agent job does not function
* The SQL Server Agent service does not execute.
You need to make sure why the SQL Server Agent service got lost.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
Domain.com contains a SQL Agent job that runs every 5 minutes.
Domain.com also has a text file called CK_Tst.log on F: drive that logs all the information of the job.
One morning during monitoring you notice the following:
* The SQL Server Agent job does not function
* The SQL Server Agent service does not execute.
You need to make sure why the SQL Server Agent service got lost.

What should you do?

A.
You should consider checking the TRANSACTION log.

B.
You should consider checking the SQLAGENT.OUT log.

C.
You should consider checking the ERRORLOG log.

D.
You should consider checking the VIEWDELETE log.



Leave a Reply 0

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