Post reply

auto start sql server agent

  • June 24, 2004 at 2:26 pm

    #162168

    Hello Everybody,

    I would like to know the command (or procedure) to set the sql server agent to Auto Start instead of using the Enterpirse Manager

    Thank you

  • June 24, 2004 at 3:17 pm

    #511880

    SQL Server Agent is a service (SQLSERVERAGENT), so it can be changed within the services applet in Control Panel / Administrative Tools.  I'm not aware of a SQL command to do it.

    Steve

  • June 25, 2004 at 8:40 am

    #511972

    You can also right-click on the server in EM and go to properties.  Under the "General" tab there is a checkbox for "Autostart SQL Server Agent".

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

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