RE: Why isn't my script running?

From: Newman, Christopher <cjnewman_at_uillinois.edu>
Date: Tue, 24 Feb 2009 12:23:50 -0600
Message-ID: <565F609E6D736D439837F1A1A797F34101C6F46C_at_ADMINMAIL1.ui.uillinois.edu>

Because the day of the week (0-6 with 0=Sunday).  

• Chris

From: oracle-l-bounce_at_freelists.org
[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?  

Hi all,

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.

---

#!/bin/ksh

USER=SYSTEM PASSWORD=pwd

sqlplus -s $USER/$PASSWORD <<EOF

set feed off

set head off

set pagesize 0

exec
dbms_stats.gather_schema_stats('TEST',ESTIMATE_PERCENT=>30,CASCADE=>TRUE );

/

exit 0;

EOF

---

 

Then in Linux:

00 01 * * 7 /home/oraprd/scripts/test_schema_stats.sh 1&2 >>
/home/oraprd/scripts/logs/test_schema_stats.log
 

Thanks,

Eugene Pipko

P Please consider the environment before printing this e-mail.  

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 24 2009 - 12:23:50 CST