[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

sql 2000: SQL Agent sometimes doesnt start

Posted on 2009-12-20
3
Medium Priority
?
218 Views
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"...so not sure why it doesnt start automcatilly SOMETIMES...
0
Comment
Question by:Camillia
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
Reza Rad earned 2000 total points
ID: 26092178
you can see event log of windows and see exactly what error happened when agent can not start, bring error here
0
 
LVL 7

Author Comment

by:Camillia
ID: 26092868
will check it and see. thanks.
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 26093724
let me know the result
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

829 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