Skip to Content

Tweaking the power of schedulers

SAP xApp Manufacturing Integration and Intelligence (SAP xMII) Business Logic Services includes its own scheduling service that allows you to execute transactions on different schedules.

  • The Schedule Editor is used to set up all scheduled jobs.
  • The Scheduler is used to view a schedule summary.

Schedulers can be used to perform the functions as defined by SAP but we can also use it to have a variety of other things.

Like when me and my teammate Rupesh were discussing about an MES simulation for a training demo, we were struck with the brilliant idea(;-)) of using scheduler to update the SQL table and display the values in LED. Now the LEDs(of the Grid) will be updated from a SQL table which is updated by a transaction.

What did we do?

  • We created a table called stage_info using MySQL for simulating the stage activities. It has two columns:
  •      o LineID(alphanumeric)
  •      o Stage_ID (alphanumeric)
  •      o Stage_status(boolean)


  • Another table line_info is created for holding the flag that whether the transaction is to be executed or not.
  • o Line_id(alphanemric)
  • o RunFlag(Boolean)

Here for the sake of simplicity, I’m using a Boolean value for stage_status(1 for in use and 0 for idle).

  • We created a transaction which fulfils the following functionality.
  • o First it will check the status of the flag for current line. If it is true then it will execute the rest of the transaction otherwise it will exit it.
  • o reads the sql table and check the status of each stage and change the status of next stage and current stage.
  • Then a scheduler is set to run for specific time interval and the transaction for this scheduler is set to the transaction that we created earlier.
  • We created a columnlights grid with source as the field of the stage_status of stage_info table. Here we set the color context as
  • o 1-Green
  • o 0-Magenta

The refresh rate of the grid was set to 15 seconds.


What did we achieve


We achieved a grid which was somewhat like this.



The grid automatically changes according to the values in the SQL table. And yippie… we did simulated MES.

This is just a tweak that one can use to simulate some time bound action. I hope this also gives readers the idea to get the things done using schedulers. This is just for prototypes and shoudl not be used on real production environments.

Be the first to leave a comment
You must be Logged on to comment or reply to a post.