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
The following tutorials contain examples of creating a scheduler job
Create Database Objects with SAP HANA Database Explorer (end of step 6)
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,