Home Library Learn Downloads Support Community
Sign in | United States - English | |
2 out of 3 rated this helpful - Rate this topic

sqlagent90 Application

SQL Server 2008

The sqlagent90 application starts SQL Server Agent from the command prompt. Usually, SQL Server Agent should be run from SQL Server Management Studio or by using SQL-SMO methods in an application. Only run sqlagent90 from the command prompt when you are diagnosing SQL Server Agent, or when you are directed to it by your primary support provider.

Copy 
sqlagent90-c [-v] [-iinstance_name]
-c

Indicates that SQL Server Agent is running from the command prompt and is independent of the Microsoft Windows Services Control Manager. When -c is used, SQL Server Agent cannot be controlled from either the Services application in Administrative Tools or SQL Server Configuration Manager. This argument is mandatory.

-v

Indicates that SQL Server 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 SQL Server Agent error log.

-i instance_name

Indicates that SQL Server Agent connects to the named SQL Server 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.

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
typographical error

In SQL Server 2008 and 2008R2 you just use SQLAGENT.EXE.  If you install 2008R2 as the default instance you can find SQLAGENT.EXE here:

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\

Use the options listed on this page to run SQL Server Agent via command line.  Don't try to use the /? switch with SQLAGENT.EXE for help...it doesn't work.

History
Second
There is no sqlagent90.exe that I can find.  90 implies that it's from SQL Server 2005.  However, sqlagent.exe exists.  Should this be changed to sqlagent.exe?
History
Does sqlagent90 still exists for SQL Server 2008 ??
Does sqlagent90 still exists for SQL Server 2008 ??

I tried to look into the location, C:\Program Files\Microsoft SQL Server\MSSQL10.InstanceName\MSSQL\Binn ( and also at C:\Program Files\Microsoft SQL Server\100\Tools\Binn), as mentioned by this article, but couldn't found that.

Can someone from Microsoft SQL Server team reply on that please ??

Thanks
Prashant Thakwani
History