Skip to Content
author's profile photo Former Member
Former Member

Scheduling flow graphs/ tasks in HANA SPS09

Hi All,

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?

Thanks in advance!!

Regards,

Dhruva

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 05, 2015 at 09:14 PM

    Hello Dhurva,

    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

    Scheduling XS Jobs - SAP HANA Administration Guide - SAP Library

    Hope this helps.

    Regards,

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Dhruva,

      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

      Thanks

      Ranjith

  • Posted on Aug 04, 2015 at 10:01 AM

    Please be a lot more specific.

    The how-to of job scheduling is covered in the documentation.

    What feature of conventional scheduling are you looking for?

    - Lars

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.