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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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.

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
Strictly speaking, this question is not a duplicate, as it refers to SSMS, the link specifically refers to SSMS express. In SSMS it could for instance also be that the person does not have sufficient rights to view SQL server agent. – Johnny DropTables Jul 23 '14 at 11:11

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:

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
You can check which version is currently installed by going to about and checking the product version against this listing – KyleMit Aug 4 '14 at 19:59

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

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

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