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 - 2001-04-22 : 20:19:55
|
Tom writes "Running SQL Server 7.0 on NT 4:
I have the SQL Agent set up on my local machine to execute the maintenance plan in EM against databases on the network. Other staff occasionally shut down a database server and when it is restarted, the maintenance plan is not executed since the agent is a service on my machine and not the network database server.
Q: If I set up the Agent as a service on the respective network database servers, will there be any conflicts with my Agent vs. the local Agent executing the maintenance plans? " |
|
|
|
|
|
Setting up SQL Agent on each database server