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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-07-31 : 03:17:01
|
| Dear All,we have so many servers in our organization, and when ever i need to work on agent, it is became head ache for me to take permission from network people and terminal connection, after that start run services.msc then start agent.is there any script to run the agent from management studio????ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-31 : 03:41:44
|
via SSMS right click on the Agent and click START
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-31 : 04:24:48
|
| in the right click start is not enabledArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-31 : 23:38:14
|
| You need local admin rights on server to start/stop service. |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2008-08-01 : 06:44:53
|
| Or if the service is already running start will be disabled , Stop and restart will be enabled.. :-)Vichttp://vicdba.blogspot.com |
|
|
|
|
|
|
sql server agent starts with script???