Skip to content

Latest commit

 

History

History
55 lines (45 loc) · 2.81 KB

File metadata and controls

55 lines (45 loc) · 2.81 KB
title sqlagent90 Application | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-non-specified
ms.prod_service sql-tools
ms.service
ms.component sqlagent
ms.reviewer
ms.suite sql
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
starting SQL Server Agent
sqlagent90 application
SQL Server Agent, starting
command prompt utilities [SQL Server], sqlagent90
ms.assetid e8b80e8d-d0c9-4500-a868-0ce08233da08
caps.latest.revision 34
author stevestein
ms.author sstein
manager craigg
ms.workload Inactive

sqlagent90 Application

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] 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.

Syntax

  
sqlagent90  
-c [-v] [-i instance_name]  

Arguments

-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.

Remarks

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.

See Also

Automated Administration Tasks (SQL Server Agent)