cancel
Showing results for 
Search instead for 
Did you mean: 

How to schedule a procedure that runs daily in hana cloud using sap bas

rajark
Discoverer
0 Kudos

Hi i am trying to schedule a hana procedure in cloud environment through sap bas and with the help of sap documents i am running below query

(CREATE SCHEDULER JOB DailyServiceMasterDataJob START TIME '00:00:00' REPEAT EVERY 1 DAY EXECUTE PROCEDURE ServiceMasterData;) but it is not deployingplease let me know is there any way to schedule a procedure in sap hana cloud foundary

Accepted Solutions (0)

Answers (1)

Answers (1)

Dan_vL
Product and Topic Expert
Product and Topic Expert

The following tutorials contain examples of creating a scheduler job

Create Database Objects with SAP HANA Database Explorer (end of step 6)
and
Scheduling SAP HANA Cloud Tasks

There are further details on the parameters for the SQL command at CREATE SCHEDULER JOB Statement.

There are also sites such as Crontab Generator that can be used to generate the cron section of the command.

Hope that helps,

Dan