March 14, 2013 at 2:02 am
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.
March 14, 2013 at 2:49 am
What version of SQL are you using? Developer, Enterprise, Express etc?
-------------------------------Posting Data Etiquette - Jeff Moden [/url]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
March 14, 2013 at 3:03 am
Microsoft sql server 10.0.1600.22
March 14, 2013 at 3:08 am
I thing Enterprise. it is not sure.how can i know that version is developer,
Enterprise and express.
March 14, 2013 at 3:55 am
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 [/url]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
March 14, 2013 at 4:03 am
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
March 14, 2013 at 4:07 am
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0
March 14, 2013 at 4:15 am
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 [/url]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
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply