Azure logic apps for scheduling Batch jobs in oracle database

Vijay 21 Reputation points

We want to migrate an existing Oracle database on Solaris on-prem to Azure Linux.

There are quite a few Batch jobs running on existing on-prem database which are scheduled through ESP scheduler which is an IBM product.

As we are moving completely to Azure linux, we would like to schedule the same Oracle Batch jobs from Azure logic apps.

Could you please let us know the procedure to implement this, the connectors we can use and the process to be followed ect.


Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
4,929 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,979 questions
No comments
{count} votes

Accepted answer
  1. Pramod Valavala 14,716 Reputation points Microsoft Employee

    @Vijay I'm not exactly familiar with how Oracle Batch Jobs work but some quick research seems to suggest that you just need to use SQL Queries.

    If that is the case, you can just use the Oracle Connector's Execute a Query or Execute a Stored Procedure from a Logic App that is triggered using a recurrence schedule.

    If it's more complex than that, you could use Azure Functions with a Timer Trigger and have custom code to work with Oracle Batch Jobs.

    Also, if applicable, a simple solution would be to just have a CRON Job on your Linux VM that runs a script.

0 additional answers

Sort by: Most helpful