How can I enable SQL Server Agent on SQL Server 2005

I can not see SQL Server Agentn on my SQL Server. I have SQL Express Trial version. How can I enable it?
LVL 1
pankajghargeAsked:
Who is Participating?
 
RiteshShahConnect With a Mentor Commented:
I don't see SQL Job, otherwise it should be there below Management, have a look at screen shot attached here.
job.JPG
0
 
RiteshShahCommented:
You will not have SQL Server Agent in express
0
 
chapmandewCommented:
sql agent doesn't come with sql express
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
pankajghargeAuthor Commented:
Ok.. In my SQL Server Configuration Manager, I can see SQK Server Agent Service. Also I can see same service in my Services....
0
 
chapmandewCommented:
in the services dialog, right click the service and go to properties...can you start it from there?
0
 
RiteshShahCommented:
do you have more than one SQL instance installed on your box?
0
 
pankajghargeAuthor Commented:
Yes I can start the service. I do not have more than 1 SQL Server instance on my machine. Here is a snapshot.
snap.JPG
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.