RE: Why isn't my script running?
Date: Tue, 24 Feb 2009 12:59:44 -0600
I clicked send a bit soon; '7' is fine for linux, on Solaris 10, 0-6 are acceptable. Sorry for the misfire!
From: Newman, Christopher
Sent: Tuesday, February 24, 2009 12:24 PM To: 'eugene.pipko_at_unionbay.com'; 'oracle-l_at_freelists.org' Subject: RE: Why isn't my script running?
Because the day of the week (0-6 with 0=Sunday).
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eugene Pipko Sent: Tuesday, February 24, 2009 12:15 PM To: 'oracle-l_at_freelists.org'
Subject: Why isn't my script running?
I am new to shell. I need to calculate stats for a schema using cron (oracle linux 4).
For some reason my script is not running.
sqlplus -s $USER/$PASSWORD <<EOF
set feed off
set head off
set pagesize 0
Then in Linux:
00 01 * * 7 /home/oraprd/scripts/test_schema_stats.sh 1&2 >>
P Please consider the environment before printing this e-mail.Received on Tue Feb 24 2009 - 12:59:44 CST