| title | sqlagent90 Application | ||||
|---|---|---|---|---|---|
| description | 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. | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 03/14/2017 | ||||
| ms.service | sql | ||||
| ms.subservice | tools-other | ||||
| ms.topic | conceptual | ||||
| ms.collection |
|
||||
| helpviewer_keywords |
|
[!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.