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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-23 : 09:25:32
|
| Mike writes "How do you start SQL Agent if stopped? MS states not to start thru Service Manager as it may corrupt registry. There is no Resource for SQL Agent in 7.0 cluster. The service is down, need to start to get jobs to run. I've just checked (enabled) the properties so Agent will start on O/S reboot or start after Unexpected stop. How do I get it to start in the meantime? Everything thing I've read states to use Cluster Admin but there is no resource for it, SQL Agent (I've checked a couple of machines and this is true). Since this is Production I cannot reboot.Thanks!" |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-09-23 : 11:30:48
|
| Can you connect to the server via EM? Under management, on SQL Server Agent, right click. you should be able to start (or stop for that matter), the agent from there. It will happen "real-time".HTH |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-23 : 14:25:08
|
| It should be a resource in the SQL group. Don't use EM on a 7.0 cluster.-Chad |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-10-11 : 05:25:29
|
| Hi Chad, just saw your response.Are there specific issues regards EM on SQL 7 cluster, or more the generic EM concerns that prompt you to say this ?TIA |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-10-20 : 04:10:16
|
| The client tool are not cluster-aware in 7.0 so if you stop SQL via EM, the cluster will see that as a failure, and failover the service.In 2000 they are cluster aware, so this doesn't happen.-Chad |
|
|
|
|
|
|
SQL 7.0 Cluster - Starting SQL Agent