How to set up a SQL Server Job via SSDT

Working on SQL Server project in Azure Data Studio

Defining a job using T-SQL

Why Drop and Create is a bad idea

Update or edit a job, when deploying a new version

Using a temporary stored procedure to deploy the jobs

Conclusions

Data Engineering made easy. Writing about things learned in data engineering, data analytics, and agile product development.