Post reply

Sql Agent auto-start

  • August 7, 2003 at 11:08 am

    #159568

    Is there a way to start Sql Agent automatically after SQL and the Agent services are shutdown manually then the Agent won't auto-start when SQL does.

    Any help is much appreciated.

  • August 7, 2003 at 11:37 am

    #469055

    I think you have to do it manually.

  • August 7, 2003 at 11:39 am

    #469057

    I have a batch that checks in a period of time the status of the services..and if someone is stopped, then it starts them.

    I don't think you can do it from inside SQL.

  • August 7, 2003 at 2:20 pm

    #469089

    I was reading an article where it states the following:

    You can run the following proc or enable it as a startup stored-proc to overcome this.

    CREATE PROC AUTOAGENT

    AS

    EXEC XP_CMDSHELL 'NET START SQLSERVERAGENT'

    go

    SP_PROCOPTION AUTOAGENT, STARTUP, TRUE

    Any comments or suggestions?

  • August 8, 2003 at 1:07 pm

    #469238

    Tested this proc and it works fine! I'm implementing accross several of my servers. Just needed to update the SQLSERVERAGENT to reflect actual SQL Agent per box.

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

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