• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

SQL Server Agent - Autostart

I was hoping someone may have some advice for how I can ensure the SQL Server Agent starts automatically with SQL Server 2000.

I have some scheduled jobs that must run and on a couple of occasions I have been stung by the agent not starting after a reboot of the PC.

Any advice is much appreciated.
1 Solution
Start -> Program Files -> MS SQL Server -> Service Manager

Then select Server and Service ("SQL Server"), click Auto-start service when OS starts
Then select Server and Service ("SQL Server Agent"), click Auto-start service when OS starts
Tricky3Author Commented:
Thanks - and I was looking for some complicated way of using xp_servicecontrol or something...

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now