• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

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?
0
pankajgharge
Asked:
pankajgharge
  • 3
  • 2
  • 2
1 Solution
 
RiteshShahCommented:
You will not have SQL Server Agent in express
0
 
chapmandewCommented:
sql agent doesn't come with sql express
0
 
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
RiteshShahCommented:
I don't see SQL Job, otherwise it should be there below Management, have a look at screen shot attached here.
job.JPG
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now