Scheduling SQL Scripts Using Jenkins


Introduction

There are scenarios where you need to schedule the SQL Server scripts without using SQL Server Agent, like when you use SQL Server Express edition. Mostly, the DBAs in this case is will choose to use the Windows task scheduler. However, Jenkins tool can help you to achieve the same result more efficiently than the Windows Scheduler, specifically in the area of logging and versioning the scripts.

This article will give you the insight to understand how you can schedule a SQL Server script using the DevOps Tool called Jenkins.

What is Jenkins?

Jenkins is an open-source automation server