Post reply

SQL Server Agent dosabled

  • July 18, 2012 at 10:33 pm

    #259582

    hi all

    SQL server agent is disabled automatically,if i reconfigure the agent "sp_configure 'Agent XPs',1". it run for one or two days, again it disable automatically. because of this all jobs are getting failed.

    so please guide me to solve the problem. please give one permanent solution.

    thanks

    Regards

    Selva

    --------------------------------------------------------

    I am Learner -- SQL

  • July 18, 2012 at 11:38 pm

    #1514606

    Have you checked the server logs?

    Have you verified that somebody/something is not stopping and restarting SQL Server?

    Same sort of question for the Agent, have you confirmed that somebody/something is not stopping the agent?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 18, 2012 at 11:55 pm

    #1514617

    You need to change the SQL Agent service Startup type to "Automatic" using SQL Server Configureation Manager (or Services applet).

  • July 18, 2012 at 11:56 pm

    #1514618

    Suresh B. (7/18/2012)

    You need to change the SQL Agent service Startup type to "Automatic" using Services applet.

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

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