sql 2000: SQL Agent sometimes doesnt start

Posted on 2009-12-20
Last Modified: 2012-05-08
We have scheduled our sql server to be rebooted once a day. Sometimes after the reboot, sql server agent doesnt start. We actually have to start it manually...

How can I debug this issue and figure out why the agent doesnt start? I looked at Services and Agent set to "Automatic" not sure why it doesnt start automcatilly SOMETIMES...
Question by:Camillia
    LVL 30

    Accepted Solution

    you can see event log of windows and see exactly what error happened when agent can not start, bring error here
    LVL 7

    Author Comment

    will check it and see. thanks.
    LVL 30

    Expert Comment

    by:Reza Rad
    let me know the result

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now