Can we schedule refresh of snapshots?

[MioYasutake]

In HANA Cloud, we can create a snapshot for a virtual table and refresh the snapshot using the following SQL.

alter virtual table "FVT_LINEITEM" refresh snapshot replica;

In a real-life scenario, we would schedule the refresh so as snapshots are refreshed at a regular interval.

What would be the recommended approach for achieving this? Is there standard tools or functions available?

I have referred to the following blog post for creating snapshots.

https://blogs.sap.com/2020/05/18/checking-the-behavior-of-sap-hana-cloud-virtual-table-replica-featu...

Best regards,

Mio

[Cocquerel · Accepted solution]

Hello,

you may embed the ALTER statement into a procedure and then schedule the procedure using CREATE SCHEDULER JOB Statement

[MioYasutake · Accepted solution]

Hi mickael.cocquerel,

Thank you very much for your response. I will try it.