what we have to do when sql server agent was down

  • how to get it out

    thankyou in advance

  • is the service stopped?

    Are you getting errors?

    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

  • error...

  • What is the error?

    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

  • Have you tried to start the service? You can do that through the Management Studio interface or by opening the SQL Server Configuration Manager. You can even use netstart commands for the service. If these don't work, do they generate an error? If so, what's the error?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Do you want to get notified when SQL Server agent goes down?

    or

    You want to know the steps/action to perform in order to restart this service?

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • Open SQL Server Configuration manager

    Right click and start the SQL Server Agent.

    If the SQL Service is stopped it will automatically kick start the service.

    If you get issue with logins open SQL Server Agent Properties -> and check the credentials.

    Start the service.

  • Look up

    http://msdn.microsoft.com/en-us/library/ms180965.aspx

    Jayanth Kurup[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

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