Re: Running tbtape from cron
Hi,
Here my sh script.
---------------- Cut here ----------------
#################################################################
#
# Script d'archivage du moteur Informix On-Line
#
# Creation le 01/09/97
#
# code retour : 0 si OK, 1 si erreur
#
#################################################################
# ---------------------------------------------------------------
# Fonctions
# ---------------------------------------------------------------
sortir()
{
echo "Abandon de la sauvegarde"
}
# ---------------------------------------------------------------
# Main
# ---------------------------------------------------------------
INFORMIXDIR=/usr/informixTBCONFIG=tbconfig.cpam
SQLEXEC=$INFORMIXDIR/lib/sqlturbo
export TBCONFIG INFORMIXDIR SQLEXEC
trap 'sortir; exit 0' 2 3
nomdev=`/bin/grep "^TAPEDEV" $INFORMIXDIR/etc/$TBCONFIG | awk '{print $2}' `
nomlog=`/bin/grep "^MSGPATH" $INFORMIXDIR/etc/$TBCONFIG | awk '{print $2}' `
echo "`date +%H:%M:%S` Lancement d'une sauvegarde moteur On-Line" >> $nomlog
$INFORMIXDIR/bin/tbtape -s << !
0
!
if [ $? -ne 0 ]
then
echo "`date +%H:%M:%S` Probleme de sauvegarde moteur On-Line" >>
$nomlog
cat $nomlog | mail informix
exit 1
else
echo "`date +%H:%M:%S` Sauvegarde moteur On-Line termine" >> $nomlog
cat $nomlog | mail informix
exit 0
fi
---------------- Cut here ----------------
Remarque :
==========
Many thanks. The fgl_getenv function run on 4GL ver 4.1 UC4
Best Regards.
-----Message d'origine-----
De : J Borys <jborys@rms.moore.com>
' : informix-list@rmy.emory.edu <informix-list@rmy.emory.edu>
Date : jeudi 6 novembre 1997 22:35
Objet : Running tbtape from cron
>Has anyone had any luck running tbtape from cron? The hint on the
>informix faq doesn't work. I am using SCO & AIX
>