Schedule Flowgraph on HANA Service

[former_member624295]

Hi Expert,

I would like to schedule flowgraph in HANA service. I follow the sap help url https://help.sap.com/viewer/d60a5abb34d246cdb4ab7a4f6b9e3c93/2.0_SPS03/en-US/701be86d4ad3470485ee4ec...

But I do not find the role or privilege in the pre-requisite step of sap help.

Althrough I follow the procedure but can not find the schedule button.

Do you have any ideas about this?

Best Regards,

Ditthanan P.

[xiaoming_wu]

check this might help

XSA based job scheduler can also be used , this is an XSA service . Users need to create Node JS application that can call the stored procedure generated out of flowgraphs . Following HANA academy video shows creating such application , you will need to modify for executing stored procedure instead . This is an XSA based feature

https://help.sap.com/viewer/4505d0bdaf4948449b7f7379d24d0f0d/2.0.02/en-US/b2aff171211c4a4dbcbb55a7eb...

https://www.youtube.com/watch?v=sLRqzcymSWs

The document you refer to is for On premise HANA (XSC)

[aparr]

Hi Ditthanan,
I came accross the same issue. I have the impression that the solution depends on the steup / environment where you HANA ist running / hostet. I didn't found any of the mentioned roles by the sap help page too because I couldn't install the Deployment Unit for SDI and there was not XS Classic Engine running on my HANA. This means, I could not register a XSJS scheduled Job, which triggers the Flow Graph. Finally we found a solution by using SAP Job Scheduler, a service on SCP Cloud Foundry, which triggers a NodeJS app via CF Task. The CF Tasks calls the respective SQL to start the Flow Graph(s). I hope this helps. Better, other and easier solutions are appreciated.

Best Alex

[former_member219740]

Hi Alex,

Could you please share or explain about the solution that you found in detail if possible please share step by step document if you have created one. I am facing a similar issue i am unable to get realtime data so i am trying to schedule the reptask/flowgraph to get the delta load. So request you to please help me with your solution.

Best Regards,

MK