Click here to Skip to main content
15,851,242 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear Friends,

I want to learn sql server Angent Services. I have installed sql server 2008 r2 Express edition in my system.. The sql server agent is not displaying. how can install that services in this edition..

Thanks & regards,
Vivek .R

What I have tried:

I have Installed Express edition.
Updated 11-Apr-16 2:01am
John C Rayan 11-Apr-16 4:47am    
Do you see SQL Server Agent in services ? Are you be able to enable it?
Vivek.anand34 12-Apr-16 23:38pm    
It showing in config manager but I can't enable it.. "The Request failed or the service didn't respond in a timely fashion. consult the event log or other applicable error logs for details" message showing When i start the agent services in config mgr.

Share this answer
The SQL Server Agent functionnality (which is used to schedule jobs on the SQL instance) is not available under Express editions. More exactly, the SQL Server Agent service is installed, but you cannot start it. This is by design, and the only way for you to start using it is to install a non-express version of SQL Server.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900