topic Re: CRON in Operating System - Linux

CRON

prasanth.ps — Thu, 23 Aug 2007 03:32:16 GMT

Hi to all...

i want to clarify one doubt.
am exporting the my oracle databse table by using the following command in the linux prompt.

$ exp username/password file=username_DDMMYYYY.dmp owner=username

I waant to run this coammnd daily 8 o clock night and i want to change the date in the file field and want to delete the previous day *.dmp file too.

Is this is possible with cron job.
if yes please explain me how to do?

thanx in advance.

Prasanth

Re: CRON

Oviwan — Thu, 23 Aug 2007 04:21:16 GMT

Hey

create (or generate through a shell script) a parameter file for the export:

$cat export.par
userid=username/password
file=username_DDMMYYYY.dmp
owner=username

then execute it from cron "exp parfile=/path/to/export.par"

Regards

Re: CRON

Ivan Ferreira — Thu, 23 Aug 2007 04:24:24 GMT

You can do it with something like this:

EXPDIR=/export
exp username/password file=$EXPDIR/$USERNAME_$(date +%d%m%Y).dmp owner=$USERNAME

if [ $? -eq 0 ]
then
find $EXPDIR -name $USERNAME*.dmp -mtime +1 -exec rm {}\;
fi