First of all, Azure SQL Database does not have the SQL Server Agent as a service. If you are running SQL Server in an Azure VM, or are using Azure SQL Managed Instance, you can use the Agent but ...

Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.

Calling SQL Server Stored procedures in Power Apps. I created a little demo app. (Yes, it doesn’t look good and wouldn’t pass my QA tests). On the top left I can add cars.

Joey on SQL Server. How To Automate Tasks in Azure SQL Database. Knowing how to automate tasks in the cloud will make you a more productive DBA. Here are the key concepts to understand about cloud ...