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?
A.
sqlcmd.exe
B.
sqldiag.exe
C.
sqlagent.exe
D.
sqlservr.exe
Explanation:
You should use the sqlagent.exe utility. The sqlagent.exe utility allows you to start SQL Server Agent from thecommand prompt. It is recommended that you run the sqlagent.exe
utility from the command prompt only whenyou want to diagnose SQL Server Agent. The syntax for using this utility is as follows: sqlagent -c [-v] [-i instance_name]
The -c parameter indicates that SQL Server Agent is running from the command prompt and is independent ofthe Microsoft Windows Services Control Manager. The -v parameter runs the SQL Server Agent in verbosemode writing diagnostic information to the command-prompt window. The -i parameter specifies the namedinstance of SQL Server to which SQL Server Agent will connect. You should not use the sqlcmd.exe utility because this utility does not allow you to diagnose SQL Server Agent. The sqlcmd.exe utility allows you to enter Transact-SQL statements, system procedures, and script files indifferent locations, including at the command prompt, in Query Editor in SQLCMD mode, in a Windows script file,or in an operating system job step of a SQL Server Agent job. You should not use the sqldiag.exe utility because this utility does not allow you to diagnose SQL Server Agent.The sqldiag.exe
utility is used to collect various types of diagnostic information from SQL Server and other typesof servers. You should not use the sqlservr.exe utility because this utility does not allow you to diagnose SQL Server Agent.The sqlservr.exe utility is a command-line utility that allows you to start, stop, and pause an instance of SQLServer 2008.Objective:
Monitoring and Troubleshooting SQL ServerSub-Objective:
Identify SQL Server service problems.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > Tools Reference >Command Prompt Utilities > sqlagent90 Application