cancel
Showing results for 
Search instead for 
Did you mean: 

How to schedule SAP HANA Stored procedure in HANA enterprise edition

0 Kudos

Dear all,

We are developing a new application(from scratch) in SAP UI5(front end) and SAP HANA(database backend). The requirement is like we need to run the stored procedure every hour, this stored procedure will do many calculations internally and update some tables in SAP HANA. The front end which we are developing in UI5 will display the records from the tables updated from stored procedure.

We would need to schedule this stored procedure to run every hour. Please let me know how we can do this ?

Regards,

Yogesh

Accepted Solutions (1)

Accepted Solutions (1)

rindia
Active Contributor
0 Kudos

Hi Yogesh,

The job scheduling feature is not yet available in the current release (1.0 SPS 06)

Please check this thread for some more info here.

But not to worry, some workaround was already done using HDBSQL and windows task scheduler to schedule jobs.

Check this document for how to schedule.

Regards

Raj

Former Member
0 Kudos

You can also use cron.d on the linux system to schedule hdbsql to call the stored procedure. This is my preferred solution as you can schedule email alerts if there is a problem.

John

rindia
Active Contributor
0 Kudos

Hi John,

Can  you please give more insight on how to use cron.d

Just eager to know about this.

Regards

Raj

kevin_small
Active Participant
0 Kudos

There is a video here about using cron: http://www.saphana.com/docs/DOC-2909

rindia
Active Contributor
0 Kudos

Thanks for the video Kevin.

Answers (0)