When I tried to start the SQLSERVERAGENT service, the below error prompt out.

Posted by Gg under Sql Server on 3/12/2011 | Points: 10 | Views : 5587 | Status : [Member] | Replies : 2
Hi,

I'm installed MSSQL 2008.
When I tried to start the SQLSERVERAGENT service, the below error prompt out.

Anyone here could help me on the error "SQLSERVERAGENT service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."


Any idea?

Thanks,
gg.




Responses

Posted by: Gsolvers on: 3/12/2011 [Member] Starter | Points: 25

Up
0
Down
Can you try to see SYstem or application logs to get the exact error?

AdminitrationTools->EventViewer

Best Regards,

VG
www.TeacherJi.com

Gg, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: PandianS on: 3/12/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi

Start the service named Alerter and then start the SQL Server Agent

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Gg, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response