Solved

How can I enable SQL Server Agent on SQL Server 2005

Posted on 2009-05-04
7
314 Views
Last Modified: 2012-06-21
I can not see SQL Server Agentn on my SQL Server. I have SQL Express Trial version. How can I enable it?
0
Comment
Question by:pankajgharge
  • 3
  • 2
  • 2
7 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24294311
You will not have SQL Server Agent in express
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 24294317
sql agent doesn't come with sql express
0
 
LVL 1

Author Comment

by:pankajgharge
ID: 24294350
Ok.. In my SQL Server Configuration Manager, I can see SQK Server Agent Service. Also I can see same service in my Services....
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 60

Expert Comment

by:chapmandew
ID: 24294358
in the services dialog, right click the service and go to properties...can you start it from there?
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24294360
do you have more than one SQL instance installed on your box?
0
 
LVL 1

Author Comment

by:pankajgharge
ID: 24294472
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
 
LVL 31

Accepted Solution

by:
RiteshShah earned 50 total points
ID: 24294490
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question