1

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

  • 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 Apr 18 '18 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 Apr 18 '18 at 8:25
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.

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:

  • 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 May 18 '18 at 14:07
  • It will be installed by default – LowlyDBA May 18 '18 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 May 18 '18 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

  • SQL Server agent feature is also available in Web and BI editions. – Shanky Apr 19 '18 at 7:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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