Restarting the Agent Problem

  • Hi.....I am currently logged into the server as the administrator and using the MSSMS to manage it....but when i right click on the SQL Agent the options to Stop Start etc are grayed out.  I know that I am logged in properly but is there something I may be missing in order to do this properly?


    New to the DBA world...thank you for your help!,

    IanR

  • What edition of sql server you are using?

    Check in SQL SERVER configuration manager..

    If it is express SQL Agent will not be available.

    MohammedU
    Microsoft SQL Server MVP

  • Its actually SQL 2005 Developer edition


    New to the DBA world...thank you for your help!,

    IanR

  • open up command prompt as administrator:

    net start sqlserveragent

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply