Using Job Scheduler to Schedule Flowgraph in HANA Cloud Foundry

[celo_berger]

Hello experts,

I'm using HANA 2.0 in Cloud Foundry. I've created a Flowgraph (fg_test.hdbflowgraph) in WEB IDE, and I'd like to schedule it using the SAP Cloud Platform - Job Scheduler tool.

I'm going through the help document but I can't seem to find a mention of how to schedule the flowgraph using this tool

https://help.sap.com/viewer/07b57c2f4b944bcd8470d024723a1631/Cloud/en-US/22c2df4d22cb4a05af4c9502a67...

This is what I see in my scheduler cockpit:

Jobs:

And under task I have the option to create a task, and when I click on the Application dropdown, I see my container, but I can't select the flow graph, and am not entirely sure what to do with it.

Any help is highly appreciated.

Thanks,

Marcelo

[former_member617538 · Accepted solution]

Hi,

The scheduling of the flowgraph is not that straightforward to do. You will need to do the following:

1) Add a nodeJS module with xsjs support enabled to your mta project

2) Add the Job scheduler (JS) service as a resource in the mta.yaml

3) Bind the JS and your hdi container resource to the nodeJS module

4) Create a xsjs file, in the file, write a query to call your flowgraph (i.e. flowgraph = stored procedure) from the xsjs)

5) Deploy the nodeJS app

6) Copy the deployed app URL to the xsjs

7) In the Job Scheduling Service dashboard, create a job and paste the URL earlier into the action

😎 Once created, you can schedule it.

[celo_berger · Accepted solution]

Thanks for the reply Mark. We figured it out a while ago, but you've summarized the steps.

It truly isn't as straightforward as the XSC method, but once you understand the process, it makes sense.

Appreciate it!

[cader_berkay]

Hi,

I'm also working on this with Business Application Studio, after doing the steps Mark described, how can we monitor these schedules and job, for example can we catch errors happening on the flows we scheduled etc.

I cannot find any documentation about it.

[narengokal]

Hi,

Did you manage to find any answer for your question ? I too am struggling with this, however, im using Business Application Studio.

If you could provide a step by step process, it will really help.

Thanks,

naren.gokal@bcx.co.za