Speak now
Please Wait Image Converting Into Text...
Embark on a journey of knowledge! Take the quiz and earn valuable credits.
Challenge yourself and boost your learning! Start the quiz now to earn credits.
Unlock your potential! Begin the quiz, answer questions, and accumulate credits along the way.
General Tech Technology & Software 2 years ago
Posted on 16 Aug 2022, this text provides information on Technology & Software related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.
Turn Your Knowledge into Earnings.
I have a weekly process that I wish to automate in Azure. The overall process consists of about 5 distinct sub-processes. Total execution time is approximately 8 hours. The sub-process technologies include:
A third party data loader program that runs on a Windows VM in Azure. This program is able to send an email upon completion. This process then needs to trigger...
T-SQL scripts running on a Windows VM in Azure which upon completion needs to trigger...
SSIS jobs running on a Windows VM in Azure which upon completion needs to trigger...
A c# application that runs on a Windows VM in Azure which upon completion needs to trigger...
Python code running on a linux VM in Azure.
My question is: what Azure technology or technologies (e.g. automation runbook, logic app) could be used to stitch this thing together to give me back my weekend? Thank you in advance.
To answer your question, yes, sure, there's ways to automate the process using Azure. I would choose Logic Apps because Business Process Automation is one of it's primary use cases. But...that's the easy part!
The hard part for you is making these disparate apps accessible to outside services. Running within Windows VM's, they don't have natural endpoints like native Azure Services.
There's lot's of ways to do this, depending on you ability to modify the VMs and programming skills.
Continued: Since all the VM are in the same domain and network connected, the first thing would look at is a bit old school (new and shiny isn't always the best), Windows Tasks. At least for 2-4.
Meaning, a Schedule Task on #2 can check for the email, then run its SQL, then start a Task on #3.
#3 can run it's jobs then start a task on #4 that runs the c# program. Then #4 can trigger the Python script. Your big gap then is how to trigger the Python script. That could be as simple as FTP'ing a trigger file for task on #5 to see.
The Windows scripting can be done in PowerShell. Not very elegant, but neither is your environment.
Finally, and almost the most important, you can use Azure Monitor and a custom log format to track the process.
No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
General Tech 9 Answers
General Tech 7 Answers
General Tech 3 Answers
General Tech 2 Answers
Ready to take your education and career to the next level? Register today and join our growing community of learners and professionals.