scheduled jobs on hana

[Former Member]

can i create a scheduled jobs on SAP HANA. like creating a store procedure and running the store procedure in schedules. so that i can pull the records from multiple tables and push it into a different table.

[Former Member · Accepted solution]

you cannot schedule a job in the HANA DB, but you can schedule a cron job on the OS of the server (or any other machine that has HANA Client installed) and let the job run the hdbsql program that can call your stored procedure or run a set of SQL statements. Run

hdbsql --help

as <SID>adm to find out more

[thomas_jung · Accepted solution]

Just to add, that we will have a job scheduler within HANA in the future.  It will be a capability of the HANA Extended Application Services (XS Engine). This is something currently in development and planned for HANA 1.0 SP6 according to the Roadmap slides we are preparing for TechEd.  Of course roadmap information is always subject to change, but I wanted to let you know this is something that is actively being worked on.

[Former Member · Accepted solution]

Hi Thomas,

Could you tell me when this feature would be available, or where to find some information regarding it if it is already working?

Thank you,

Hunor

[thomas_jung · Accepted solution]

The Job Schedule did not make it into SP6 as original planned at the time of this posting.  It is currently planned for first release with SP7; although some features won't come until SP8.  SP7 is planned to ship at the end of November 2013 and SP8 is currently planned for Q2 of 2014.

[Former Member · Accepted solution]

Hi Thomas,

We tried the Job Scheduler and it works great. Now we have some questions regarding the syntax of the scheduler.

Take following example from the developer guide,

2013 * * fri 12 0 0

Run the job every Friday in 2013 at 12:00.

1. All the date/time specified are interpreted as UTC time, right? Is there anyway to specify the time zone or specify the time as local time?

2. Is there any API to verify the validity of the input string? e.g. "2013 02 31 fri 12 0 0".

Thanks a lot.

Levy

[thomas_jung · Accepted solution]

I will post the same response that I sent to you via email on this topic.

1. 1. UTC only in the XSJOB definition file.
2. 2. I’m not really sure what you are asking for here.  If you supply something that is totally incorrect according to the XSCRON syntax, you will get an activation error.  You are wanting the activation to validate you have a real date?  Have you tried that to see if it will activate?