Please suggest any ideas/ process for Scheduling Flowgraphs or Task flows in HANA SPS09 which can match the conventional job scheduling we have in BO Data Services?
Flow Graphs creates a stored procedure. You need to schedule this stored procedure to be run at desired frequencies. The detailed documentation for scheduling a job in HANA XS can be found below
I am going through the same requirement to schedule the flow graphs. But in my case not i am using TASKs instead of procedures as my flow graphs are real time. Hence i just need to start them once.
But we have 100+ tables hence trying to write some SQLSCRIPT to just start them from a control table but i am unable to handle the exception column store 2048. As the SQL exception doesn't support that code.
So when i was searching for alternatives i saw your blog, i tried to do it with xsjob but my questions are
1) were you able to handle errors in xs job and proceed forward in execution of the other.
2) or just created one xsjob for one procedure and checked in error log if it fails
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.