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

[rajark]

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

[Dan_vL]

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