PrepAway - Latest Free Exam Questions & Answers

Tag: start sql server command prompt

Which command-line utility should you use to do this?

You are the database administrator of your company. You maintain an instance of SQL Server 2008 named SQL1 .
SQL1 contains a database named Employees that contains information about the company’s employees.You create a maintenance job for the Employees database.
You configure the job to run when the processorutilization on the server is below 20 percent. After several days, you discover that the maintenance job has not run.
You discover that the SQL Server Agentservice is not running. You try to start the SQL Server Agent by using SQL Server Management Studio, but theagent will not start.
You want to diagnose the problem with the SQL Server Agent. Which command-line utility should you use to do this?