SQL Agent Stops On Server Restarts

  • Hi,

    My SQL Agent STOPS every time my Server Restarts,

    is there anything that SQL Agent should start automaticlly

    Thanks

    Parth

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

  • 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

  • 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