Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This question already has an answer here:

I have SSMS 2012 installed on my laptop, and SQL Server 2012 on my hosting, but when i try to schedule a sql job i didn't find "SQL Server Agent" in the left side list!!?

share|improve this question
    
You need to identify: (a) whether your local SQL Server instance is Express or not; (b) whether the hosted SQL Server instance is Express or not; (c) whether your copy of Management Studio is the Express edition. For (a) and (b) you can check using SELECT @@VERSION; in a query window against each instance, and for (c) you can check Help | About in the application. –  Aaron Bertrand Oct 9 '13 at 14:04
add comment

marked as duplicate by Jon Seigel, RolandoMySQLDBA, Kin, billinkc, marc_s Oct 9 '13 at 21:01

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

3 Answers

If you have Management Studio Express installed (any version prior to SQL Server 2012 SP1), it simply doesn't contain any facility for SQL Server Agent (no matter which edition you're trying to manage). You can fix this by getting the very latest version from here:

http://www.microsoft.com/en-us/download/details.aspx?id=35579

You want the file SQLManagementStudio_x64_ENU.exe (or the one with x86 in the name if you have a really old 32-bit machine). This is the first version of Management Studio that has been offered fully functional and license-free.

Once you install this version of Management Studio, you will have access to SQL Server Agent when managing any instances of the SQL Server engine that support SQL Server Agent. Of course that won't help you create jobs on instances of SQL Server Express, since it doesn't have Agent at all.

share|improve this answer
add comment

SQL Server Express doesn't have the SQL agent (the service gets installed but you can't enable it) so you won't see any of this section in SSMS.

If you want to schedule tasks you will have to use SQLCMD and the windows task scheduler. This article explains how to schedule backups in this way, but the same principle can be used to run any SQL script:

How to schedule and automate backups of SQL Server databases in SQL Server Express

share|improve this answer
    
so how can i schedule SQL server job!!? –  Fadi Khalil Oct 9 '13 at 10:44
    
I've added some extra info to help you out. –  steoleary Oct 9 '13 at 10:56
add comment

As steoleary said, SQL Server 2012 Express doesn't support SQL Server Agents

Only the following SQL Server 2012 editions support SQL Server Agents: Enterprise, Business Intelligence, Standard and Web

See all the features by edition on MSDN: Features Supported by the Editions of SQL Server 2012

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.