Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQLAgent services not coming up

Author  Topic 

Priyapathi
Starting Member

1 Post

Posted - 2006-09-27 : 20:15:10
Hi Friends,

SQLAgent services are not coming up automatically in one of the production box after server reboot during maintenance window.But SQLserver services are coming up automatically.
could anyone suggect me a solution to solve this issue?
Thanks in advance for all your valuabl inputs.

Regards,
Priya

sphadke
Yak Posting Veteran

55 Posts

Posted - 2006-09-27 : 20:30:22
Go to Start -> Settings -> Control Panel -> Admin tools -> Services and look for the sql server agent service. check to see what the startup type is. If it's set up manual -> double click on your agent service and from the drop down box select automatic and OK and you should be good to go.


Sachin
Go to Top of Page
   

- Advertisement -