Crontab file sample

# crontab.sample:
# Sample crontab file to be included in the root crontab jobs.
# --------------------------------------------------------------------------
# Task:
# Submits backup commands at regularly scheduled intervals
# using the SAP HANA command line interface hdbsql.
# --------------------------------------------------------------------------
#      *****     NOTE     *****     NOTE     *****     NOTE     *****
#
#          This file is intended only as a model and should be
#          carefully tailored to the needs of the specific site.
#
#      *****     NOTE     *****     NOTE     *****     NOTE     *****
# --------------------------------------------------------------------------
#
# Remarks on the crontab file format:
#
# Each crontab file entry consists of a line with six fields, separated
# by spaces and tabs, that contain, respectively:
#   o The minute (0 through 59)
#   o The hour (0 through 23)
#   o The day of the month (1 through 31)
#   o The month of the year (1 through 12)
#   o The day of the week (0 through 6 for Sunday through Saturday)
#   o The shell command
# Each of these fields can contain the following:
#   o A number in the specified range
#   o Two numbers separated by a dash to indicate an inclusive range
#   o A list of numbers separated by commas
#   o An * (asterisk); meaning all allowed values
#
# --------------------------------------------------------------------------
#
# For the following examples, the system id of the SAP HANA database
# is assumed to be 'GT3', the instance number 0 and the username 
# of the database instance owner 'gt3adm'.
#
# --------------------------------------------------------------------------
# Full database backup, scheduled every weekday at 8:00 p.m. providing the
# database user name (system) and password (manager) on command line
#
0  20  * * 1-5   
/bin/su - gt3adm -c "hdbsql -i 0 -u system -p manager 
\"backup data using backint 
('/usr/sap/GT3/SYS/global/hdb/backint/full_weekday_$(date +'m%d')')\""
#
#
# Full database backup, scheduled at weekends at 9:00 a.m. using a key 
# store entry named TSM_BACKUP to connect to the database (please refer 
# to the SAP HANA administration guide for details how to create a key 
# store entry)
#
0  9  * * 0,6   
/bin/su - gt3adm -c "hdbsql -i 0 -U TSM_BACKUP 
\"backup data using backint 
('/usr/sap/GT3/SYS/global/hdb/backint/full_weekend_$(date +'m%d')')\""
#