Post reply

SQL Agent Stops On Server Restarts

  • May 6, 2009 at 12:26 am

    #202960

    Hi,

    My SQL Agent STOPS every time my Server Restarts,

    is there anything that SQL Agent should start automaticlly

    Thanks

    Parth

  • May 6, 2009 at 12:40 am

    #989349

    set sql server Agent service startup type to Automatic.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • May 6, 2009 at 2:17 am

    #989369

    Go to Start, Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server Configuration Manager and select SQL Server 2005 Services. Right click over SQL Agent and select Properties. On the Service tab click on Start Mode - you'll then be able to use the drop down menu to select Automatic startup. You'll need to make sure that the account running the Agent Service has Log on as Service rights too.

    Cath

  • May 6, 2009 at 5:22 am

    #989431

    You can set the sql agent startup to automatic mode.This option is available in windows services

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

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

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