| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
sqlagent90 Application |
The sqlagent90 application starts SQL Server Agent from the command prompt. Use it when diagnosing SQL Server Agent or when directed by your support provider. |
markingmyname |
maghan |
03/14/2017 |
sql |
tools-other |
conceptual |
|
[!INCLUDEsqlserver] The sqlagent90 application starts [!INCLUDEssNoVersion] Agent from the command prompt. Usually, [!INCLUDEssNoVersion] Agent should be run from [!INCLUDEssManStudioFull] or by using SQL-SMO methods in an application. Only run sqlagent90 from the command prompt when you are diagnosing [!INCLUDEssNoVersion] Agent, or when you are directed to it by your primary support provider.
sqlagent90
-c [-v] [-i instance_name]
-c
Indicates that [!INCLUDEssNoVersion] Agent is running from the command prompt and is independent of the Microsoft Windows Services Control Manager. When -c is used, [!INCLUDEssNoVersion] Agent cannot be controlled from either the Services application in Administrative Tools or [!INCLUDEssNoVersion] Configuration Manager. This argument is mandatory.
-v
Indicates that [!INCLUDEssNoVersion] Agent runs in verbose mode and writes diagnostic information to the command-prompt window. The diagnostic information is the same as the information written to the [!INCLUDEssNoVersion] Agent error log.
-i instance_name
Indicates that [!INCLUDEssNoVersion] Agent connects to the named [!INCLUDEssNoVersion] instance specified by instance_name.
After displaying a copyright message, sqlagent90 displays output in the command prompt window only when the -v switch is specified. To stop sqlagent90, press CTRL+C at the command prompt. Do not close the command-prompt window before stopping sqlagent90.