-
environment setup inside cron job
I like to schedule a job to be run at 8:00pm every night, and I know very a little about cron
job, basically I just want to get the exp of the database every night. Please correct me if I
am wrong. I have the script as below:
export ORACLE_SID=TEST
exp system/manager file=/u02/backup/TEST/exp_TEST_full.dmp
log=/u02/backup/TEST/exp_TEST_full.log full=y direct=y
and this script is save as backup_TEST.sh and it located on:
/home/oracle/TEST/backup_TEST.sh
seem like I have problem with setting the environment in my script but I used the same command to set environment when I do stuffs on the server and it worked.
Any advise of what command I should type inside the script????
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|