SQL Server Agent not showing up under Object Explorer

Posted on 2008-11-16
Last Modified: 2012-05-05
Select @@Version = Standard
SELECT serverproperty(edition) = standard
SELECT serverproperty(editionid) = 2
All the above queries shows that version is STANDARD.
Here I am not able to view SQL SERVER ANGENT under the object explorer. Enabled under SQL Sever configuration manager.
Here please note that on the server the tool is MICROSOFT SQL SERVER MANAGEMENT STUDIO EXPRESS.
This has been installed by one of our vendor.

Please advice

Please suggest any tips for enabling the SQL Server Agent so that I can schedule the backups?
Question by:fyzalkabu
    LVL 18

    Accepted Solution

    Hi fyzalkabu,

    If the tool is SQL Server Management Studio Express then there is no SQL Server Agent. It appears  that you are using SQL Standard Edition... I wonder why Studio Express is installed instead of Studio. You can download a free scheduler that is actually pretty good for Express at .



    Author Comment

    Thanks Jim,
    Can you please answer one more question here..

    By default when installing SQL Server standard edition , it should come SQL Server Mangement Studio, AND NOT SQL Server Management Studio Express.
    How is this possible..? i.e. version is STANDARD but tool is SSMSE. How is this installed.

    LVL 37

    Assisted Solution

    hi fyzalkabu,

    I think you should ask your vendor why they installed the Express edition of SSMS.

    SSMSE is a free download from Microsoft, meant to manage SQL Server Express Edition.  Of course it's compatible with the other editions as well but you don't get the extra functionality, as you've noticed.
    LVL 18

    Expert Comment

    Hi fyzalkabu,

    By default yes that is true but I think that you can opt to not install Studio, but its beyond me why someone would install Express in its place.

    I think that the vendor needs to do some explaining.




    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now