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 |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2011-03-04 : 01:03:19
|
| Hi everybody, why does the sql agent always appears in disable mode when login to sql server.I need to manually start the sql agent everytime i login.Is it a common thing or do i need to change any settings. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-03-04 : 07:35:30
|
| yes,it is set to auto start. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-04 : 14:32:32
|
| Is the SQL Server Agent account a domain account? |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-03-05 : 00:33:00
|
quote:
Originally posted by russell
Is the SQL Server Agent account a domain account?
yes it is a domain account... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-05 : 11:16:46
|
| Is the domain controller, and/or the SQL Server rebooting?What do you see in the application event logs? |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-03-07 : 01:49:21
|
quote:
Originally posted by russell
Is the domain controller, and/or the SQL Server rebooting?What do you see in the application event logs?
*The local host server is not running.*SQL server agent starting under windows NT service control.*local computer is running windows NT 6.1(7100).*There are 12 subsystems in the subsystem cache.there are still many more but i think they are related to my running jobs. |
|
|
|
|
|
|
SQL Agent