How to setup a job to change the backup ID

[Former Member]

Hi,

We know that SAP hana's backup will use the same backup file names once the configuration is done for backup.

To avoid overwritting the previous backup files, we have following options (note that we are using "file" not "backint")

1) rename the generated backup files after the backup is done;

or

2) move the generated backup files to another location.

We want to achieve above goals by

1) OS level cron jobs

or

2) an xsjob in xsengine.

The challenge is that cron can only be started at predefined time while the the backup job can take various time to finish.

Therefore we wonder if xsenigin can provide any event-dependent job scheduling to help with this?

Questions:

1) is there any way to detect backup status automatically at OS level?

2) is there any 3rd party scheduler for Hana?

Thanks!

[Former Member · Accepted solution]

Actually you can assign unique names for backups.

Suppose we have $DAY = 'Friday'

hdbsql -n localhost -i [instance] -u [db user] -p [passwd]  "BACKUP DATA USING FILE ('$DAY')"

will generate files like Friday_databackup_0_1, Friday_databackup_1_1 etc