How to Create Elastic Jobs in Azure SQL Database Using T-SQL - Part 4 | Data Exposed

In this episode of Data Exposed, Kate Smith walks us through the process of how to create Elastic Jobs for Azure SQL using T-SQL.

0:00 Introduction
1:00 Demo
7:35 Where to create jobs
8:47 Advantages of using T-SQL

🎞️ Elastic Jobs in Azure SQL Database Series:

✔️ Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #AzureSQLDatabase #ElasticJobs

[udararatnayake]

its very useful. But missing part is not mention how to create creditails and correct dbname for exclude . ex ? or elasticjobtarget2

[kimtuan]

after a elastic job agent is being created on Azure portal. How can I connect the new job database to create credential and target group?

[ermalhalilaga]

It was a very useful video, congratulations :)

[PumpkinIssues]

watched the whole last video thinking they were only gonna show powershell :(. This is a great series btw

[rajeevsharma]

What is the business case for the elastic job? Just to elaborate is it doing kind of maintenance /housekeeping job in the DB?