How could a batch (* .bat) process run on Azure without using VMs or servers, only PAAS or SAAS services?
It is about extracting a CSV file from an SFTP server visible from the Internet, taking it to some storage in the Cloud and then processing it with a Java program (.jar) that, in essence, is responsible for importing the records into a Azure SQL Database. In extreme case, you could change the .jar for another program or another method. I hope you can help me. Thanks.
You currently have two options to run your code in Microsoft Azure as PaaS:
Azure Web Jobs in Azure App Service: will allow you to run your .bat on demand. The service starts from a free level, and can scale in number of cores and memory according to your need. More information at: link .
Azure functions: if you want to go to a "serverless" scheme to execute your code. The cost is given by the number of executions and the computational cost (measured by the amount of memory used during the execution time). It has a fairly high threshold before starting to charge for the service. More information at: link