Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql server Agent is not found in Object Explorer Expand / Collapse
Author
Message
Posted Thursday, March 14, 2013 2:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 15, 2013 3:08 AM
Points: 7, Visits: 16
Dear cronies

I have to need scheduler used to run the stored procedure but i can't schedule because of sql server agent instance is not available in Object Explorer.

But this services i am started in sql server configuration manager.




Post #1430807
Posted Thursday, March 14, 2013 2:49 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:27 AM
Points: 3,302, Visits: 3,567
What version of SQL are you using? Developer, Enterprise, Express etc?

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1430818
Posted Thursday, March 14, 2013 3:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 15, 2013 3:08 AM
Points: 7, Visits: 16

Microsoft sql server 10.0.1600.22
Post #1430821
Posted Thursday, March 14, 2013 3:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 15, 2013 3:08 AM
Points: 7, Visits: 16

I thing Enterprise. it is not sure.how can i know that version is developer,
Enterprise and express.
Post #1430822
Posted Thursday, March 14, 2013 3:55 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:27 AM
Points: 3,302, Visits: 3,567
Run
SELECT @@VERSION

That should give you a whole load of info about your server. Best bet to see all the information is to run it to text (ctrl + t) otherwise it is just one long cell. the results I got on one of my servers was:-

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (Intel X86)
Jun 28 2012 08:42:37
Copyright (c) Microsoft Corporation
Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)







-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1430846
Posted Thursday, March 14, 2013 4:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:10 AM
Points: 5,437, Visits: 10,129
If you can't see SQL Server Agent, it may be because you don't have the necessary access. Are you a member of the sysadmin server role, or a member of one of the SQLAgent database roles in msdb?

John
Post #1430851
Posted Thursday, March 14, 2013 4:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 15, 2013 3:08 AM
Points: 7, Visits: 16
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0
Post #1430852
Posted Thursday, March 14, 2013 4:15 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:27 AM
Points: 3,302, Visits: 3,567
Thanks for that but the bit I'm looking for is :-

Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

There is a version of SQL server (express) that does not have SQL agent, therefore you would not see it.

John is right about permissions, you need to rule that one out at the same time.

Have you checked to see if anyone else can see it?


-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1430858
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse