| Author |
Topic |
|
brentb08
Starting Member
9 Posts |
 Posted - 2007-05-07 : 08:25:06
|
| I have a SQL Server agent that keeps stopping for no reason. It happens about every other day. I have to go in on the server and manually start it. What would cause this to happen? We have about 50+ computers that need to sync with the server and do so successfully without having to manually start the agent every other day. How do we fix it? |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-07 : 08:41:32
|
| Have you got it set to auto-restart if it fails unexpectedly?(It would still be good to find the cause, but that might ease the pain!)Kristen |
 |
|
|
brentb08
Starting Member
9 Posts |
Posted - 2007-05-07 : 09:16:32
|
| How do I set it to auto-restart?My SQL knowledge is pretty limited.... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-07 : 12:21:54
|
| SQL 2000:Enterprise manager : open Server "tree" : Management : RightClick SQL Server Agent : Properties : [Advanced]"Auto restart SQL Server if it stops unexpectedly""Auto restart SQL Server Agent if it stops unexpectedly"Kristen |
|
|
|
brentb08
Starting Member
9 Posts |
Posted - 2007-05-07 : 13:18:14
|
| Thanks! |
|
|
|
brentb08
Starting Member
9 Posts |
Posted - 2007-05-10 : 13:01:33
|
| I am still having problems with this SQL Server Agent stopping for no reason even after I have it set to Auto Restart. Any tips or ideas? Any troubleshooting steps I should go through? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
brentb08
Starting Member
9 Posts |
Posted - 2007-05-11 : 13:02:50
|
| The error log doesn't really tell me anything. This SQL Server Agent is on a tablet PC that is used out in the field every day. It seems like every time he takes the tablet out in the field, off the network, then brings it back in and docks it, that is when it happens. It is happening every single day. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-11 : 13:08:12
|
| What's sql service startup account? Any related message in event logs? |
|
|
|
brentb08
Starting Member
9 Posts |
Posted - 2007-05-11 : 13:16:59
|
| DOM1\uaserverI don't know about the event logs. The computer is actually off the network at the moment |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-11 : 13:51:02
|
| "This SQL Server Agent is on a tablet PC that is used out in the field every day."I'm not understanding something here ... surely the SQL Server Agent Service is running on a server back in the office?If its actually running on a portable device maybe its getting hosed when the device going into Hibernate (or some other power saving mode)Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-11 : 15:14:35
|
| If dom1 is domain name, then sql service will stop once you take the machine offline. |
|
|
|
brentb08
Starting Member
9 Posts |
Posted - 2007-05-14 : 07:44:07
|
| Yes, it is running on on the server back in the office...my bad. In so many ways I was trying to say that the tablet is used out in the field and it is off and on the network a couple times a day. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-14 : 08:17:19
|
| If its just a "client" it shouldn't effect the SQL Server Agent Service at all. Although it might, I suppose, if there is some sort of "replication" tasks running trying to communicate with the Tablet?Kristen |
|
|
|
brentb08
Starting Member
9 Posts |
Posted - 2007-05-14 : 09:40:17
|
| Yes there are replication tasks that running trying to communicate with the tablet. I will usually get a call from the guy about once every 2 days saying that he cannot sync up (In our mapping software, we can manually sync with the server so that the changes will replicate back to the main server and out to all the other client machines). The last time I had to restart the SQL Server Agent was back on Friday morning and the computer has been off and on the network a few times since then and as of this morning it was still working. |
|
|
|
brentb08
Starting Member
9 Posts |
Posted - 2007-05-16 : 07:59:41
|
| What if we uninstall/reinstall the service pack? I have heard that might remedy the problem. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-16 : 09:57:41
|
| You can't uninstall sp, but can try apply it again. |
|
|
|
|
SQL Server Agent Stopping