Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003

    Unanswered: starting ssql server agent

    How can i start my sql server agent.

  2. #2
    Join Date
    Feb 2003
    Auckland, NZ

    Re: starting ssql server agent

    sqlagent Application
    The sqlagent application starts SQL Server Agent from the command prompt. Usually, SQL Server Agent should be run from SQL Server Service Manager or by using SQL-DMO methods in an application. Only run sqlagent from the command prompt when you are diagnosing SQL Server Agent, or when you are directed to by your primary support provider.

    sqlagent -c [-v]


    Indicates that SQL Server Agent is running from the command prompt and is independent of the Windows NT Service Control Manager. When -c is used, SQL Server Agent cannot be controlled from either the Services application in Control Panel or SQL Server Service Manager.


    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.

    After displaying a copyright message, sqlagent displays output in the command prompt window only when the -v switch is specified. To stop sqlagent, press CTRL+C at the command prompt. Do not close the command-prompt window before stopping sqlagent.
    JJ Kennedy
    Double J IT Solutions

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  3. #3
    Join Date
    Apr 2003

    Re: starting ssql server agent

    go to EM, under the server, click Management to expand the folder, then right click on "SQL server agent", click Start submenu.

  4. #4
    Join Date
    Aug 2002
    Also refer to books online for such question which can be used as first hand information.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts