how to implement automation for initiating and halting SAP BTP HANA DB?

[rupambecs999]

I utilize a free HANA DB for my application, but I'm facing the issue of the instance being halted regularly. I wish to avoid the manual restarting process. Is there a method to enable automatic startup using a scheduler?

I'm aware that the following command can be used to initiate the DB:

[yogananda]

rupambecs999

Yes, you can enable the SAP Automation Pilot, which will send a alert if your HANA DB is on stop and restarts automatically. You can enable Autoscaler if incase your db needs to be scaled up as app memory exceeds.

there are tutorials about this in developers.sap.com

[rupambecs999]

In my case, I'm utilizing the Europe Netherlands region. However, the Automation service isn't accessible in my region. Given this situation, what would be the recommended approach to achieve the same automation?