SQL Server Agent folder - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

SQL Server Agent folder

Author

Topic

jim_jim
Constraint Violating Yak Guru

306 Posts

Posted - 2010-07-21 : 15:56:22

Hi
I am very new sql server administration.I have downloaded Sql server 2008 and see I dont have the sql server agent folder in the management studio.

What do i need to have to get the sql server agent

Please advise

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-21 : 15:58:11

Are you using Express? Express doesn't have the Agent as a feature.

If you need to schedule things to run, you can use Task Scheduler or Service Broker.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

jim_jim
Constraint Violating Yak Guru

306 Posts

Posted - 2010-07-21 : 16:15:00

I have downloaded management studio separately and not sure whether it is Express edition or not
how do i know it is express edition

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-21 : 16:20:14

SELECT @@VERSION to check the database server
And Help About to check SSMS.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

jim_jim
Constraint Violating Yak Guru

306 Posts

Posted - 2010-07-21 : 16:26:47

My Database Server version is Microsoft SQL Server 2005
and
SSMS version is 10.0.1600.22(SQL_Prerelease)

will this version do not have the SQL server agent capability?

Also what version of software do i need to buy If i need SQl Server management studio with Sql server agent,BIDS etc

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-21 : 16:32:23

Do you have a different SSMS version to test with? I don't have any systems with the SQL_Prerelease on them. My 2005 and 2008 client tools can see my Agents just fine.

You'll need to do a comparison of the different editions: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

We use the most expensive edition and licensing scheme (Enterprise with CPU licenses), but that's because that's what we need. Your mileage will vary.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-07-21 : 22:19:59

what's the result of

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

jim_jim
Constraint Violating Yak Guru

306 Posts

Posted - 2010-07-22 : 08:02:44

9.00.4273.00 SP3 Standard Edition (64-bit)

The Above is what i got after executing the query.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-07-22 : 13:21:04

You downloaded the Express version of SSMS, which doesn't have SQL Agent support. You need the full version. The media containing the server software also has the client tools. You can download it here http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources