1

Is there any way to add it in SQL Server Express edition?

Improve this question
2
  • 2
    Expression edition doesn't include this feature. You can sess SQL Server Agent service but cant start it. you can use windows task scheduler in place of SQL Server agent
    – Rajesh Ranjan
    Commented Apr 18, 2018 at 6:25
  • 1
    You need to know what features are available with which version. Express edition has limitations. Have a good look at those..You will need to use the Task Scheduler for scheduling anything in Express edition.
    – Ramakant Dadhichi
    Commented Apr 18, 2018 at 8:25

3 Answers 3

Reset to default
3

No you cannot have SQL Server agent feature in express edition of SQL Server. To get that you would have to upgrade to licensed version of SQL Server like Enterprise, Standard, Web and Developer editions. Just so that you know you can see the SQL Server agent services in express edition but that cannot be started. If you want to use scheduling to schedule jobs you have to rely in windows scheduler

From SQL Server 2014 onwards the developer edition is free to download and use and this version has SQL Server agent feature. The only limitation is you cannot use developer version in production, you can ONLY use it in development and testing environment.

Improve this answer
2

There is no SQL Agent included in SQL Server Express. You'll need to find a different way to schedule jobs unless you switch to a different edition of SQL Server.

Other options include:

  • Using Task Scheduler
  • Third party software, like JAMS Scheduler which has a community version free for 1 year with 50 job runs/day (no affiliation)
  • Develop something custom
  • Run the jobs manually :)

References:

Improve this answer
3
  • Which feature in the Developer installation contains the SQL Agent? I don't want to install all features since I only need the Agent.
    – Jan
    Commented May 18, 2018 at 14:07
  • It will be installed by default
    – LowlyDBA - John M
    Commented May 18, 2018 at 14:24
  • I found out that you only need to install the first/top feature "Database Engine Services". You can leave all other features unchecked which saves you a ton of Gigabytes.
    – Jan
    Commented May 18, 2018 at 14:27
1

SQL server 2014 express does not have SQL Server agent, only available on Standard and Enterprise editions. You can take help from creating batch files and running them through CMD, Windows scheduler will let you schedule it.

Here are Features supported by the different editions of SQL Server 2014

Improve this answer
1
  • SQL Server agent feature is also available in Web and BI editions.
    – Shanky
    Commented Apr 19, 2018 at 7:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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