Re: Why isn't my script running?
- From: Paul Linehan <linehanp@xxxxxx>
- To: eugene.pipko@xxxxxxxxxxxx
- Date: Thu, 26 Feb 2009 06:58:57 +0000
> Here is the script:
<snip...>
> exec dbms_stats.gather_schema_stats('TEST',ESTIMATE_PERCENT=>30,CASCADE=>TRUE)
<snip>
Why don't you set up a job in the dbms_scheduler instead of running a
shell script?
easier - not environment dependent
Or have I missed something completely obvious?
Paul...
> Still won't fire from cron, but runs as $sh test_schema_stats.sh
If you do it inside the db server, you don't have to worry about
your OS environment or anything else - the reason Oracle
did this in the first place.
Paul...
--
linehanp@xxxxxx
Mob: 00 353 86 864 5772
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Why isn't my script running?- Eugene Pipko
- » RE: Why isn't my script running?- Newman, Christopher
- » RE: Why isn't my script running?- Xu, Roger
- » Re: Why isn't my script running?- Dan Norris
- » Re: Why isn't my script running?- Jared Still
- » Re: Why isn't my script running?- Dan Norris
- » Re: Why isn't my script running?- Jared Still
- » Re: Why isn't my script running?- Stefan Knecht
- » Re: Why isn't my script running?- Jared Still
- » Re: Why isn't my script running?- Rich Jesse
- » RE: Why isn't my script running?- Newman, Christopher
- » RE: Why isn't my script running?- Eugene Pipko
- » RE: Why isn't my script running?- Channa, Santhosh
- » RE: Why isn't my script running?- Mercadante, Thomas F (LABOR)
- » RE: Why isn't my script running?- Eugene Pipko
- » RE: Why isn't my script running?- Bobak, Mark
- » RE: Why isn't my script running?- Eugene Pipko
- » RE: Why isn't my script running?- Bobak, Mark
- » RE: Why isn't my script running?- Eugene Pipko
- » Re: Why isn't my script running?- Daniel Fink
- » RE: Why isn't my script running?- Bobak, Mark
- » RE: Why isn't my script running?- Eugene Pipko
- » RE: Why isn't my script running?- Sais, Gene
- » RE: Why isn't my script running?- Bobak, Mark
- » RE: Why isn't my script running?- Bobak, Mark
- » RE: Why isn't my script running?- Sais, Gene
- » RE: Why isn't my script running?- Bobak, Mark
- » RE: Why isn't my script running?- Mercadante, Thomas F (LABOR)
- » RE: Why isn't my script running?- Eugene Pipko
- » Re: Why isn't my script running? - Paul Linehan
- » Re: Why isn't my script running?- amonte
- » RE: Why isn't my script running?- Eugene Pipko