RE: Why isn't my script running?

  • From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
  • To: 'Paul Linehan' <linehanp@xxxxxx>
  • Date: Thu, 26 Feb 2009 08:20:22 -0800

1. I am running 9.2
2. Wanted to learn now to do it in cron

Eugene Pipko
  Please consider the environment before printing this e-mail.

-----Original Message-----
From: Paul Linehan [mailto:linehanp@xxxxxx] 
Sent: Wednesday, February 25, 2009 10:59 PM
To: Eugene Pipko
Cc: Mercadante, Thomas F (LABOR); oracle-l@xxxxxxxxxxxxx
Subject: Re: Why isn't my script running?

> 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
��i��0���zX���+��n��{�+i�^

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2009