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 |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2010-02-17 : 13:40:11
|
| Good afternooin.Im a newbie specially in SQLSERVER 2008.After migrating from 2000 to 2008 version, in order to restart the instance, i stop the SQLSERVER serve and this service stops the SQLSERVER agent, to start the service I start SQLSERVER agent service which starts SQLSERVER service, an its OK.But the problem is , in a few minutes i noticed that the SQLSERVER agent is not started (down). The question is:1. What cause the SQLSERVER agent to be stopped and why?2. The proceses running in the server database are working properly, and what is the impact that this SQLSERVER agent is not working?3. How can i keep this service started?Ill appreciate your help |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-17 : 14:22:38
|
" what is the impact that this SQLSERVER agent is not working"Any scheduled tasks / jobs will NOT run  "3. How can i keep this service started?"In SSMS Right-click SQL Agent and select "Auto restart SQLK Server Agent if it stops unexpectedly"BUT ... it should not suddenly stop, I recommend that you investigate the cause.Anything relevant in SQL logs? Event log? |
 |
|
|
alejo46
Posting Yak Master
157 Posts |
Posted - 2010-02-22 : 14:02:39
|
| Good afternoonin SQLSERVER 2008 how do i get to SSMS and Right-click SQL Agent and select "Auto restart SQLK Server Agent if it stops unexpectedlyfind the option ? i coudnt find it. Thanks |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-22 : 14:04:45
|
| Are you using SQL Express? |
|
|
|
alejo46
Posting Yak Master
157 Posts |
Posted - 2010-02-22 : 14:08:17
|
| No, just in SSMS i find thw SQLServer Agent icon with a red X, but i tried to start it manually but failed, maybe because there are some processes running? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-22 : 14:57:20
|
| "i tried to start it manually but failed, maybe because there are some processes running?"Doubt is has to do with running processes.Try starting it in "Administrative Tools : Services" and seeing if you get a more helpful message?Suggest check Event Log for error/informational messages too |
|
|
|
alejo46
Posting Yak Master
157 Posts |
Posted - 2010-02-23 : 17:38:55
|
| In ADMIN Tools i started the SLSERVER y SQLSERVER agent successfully, but in few minutes the SQLSERVER agent stops unedxpectively, i checked up the event logs and i found a error message:event id:103 SqlServer agent could not be started (reason:cannot create a new session)Do you know exactly what does it mean?I'd appreciate your help, thanks a lot |
|
|
|
|
|
|
|
|
SqlSever agent is not started