Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cron scripts

Re: Cron scripts

From: Ron Franks <Ron.Franks_at_trw.com>
Date: Fri, 11 Jun 1999 18:33:00 +0100
Message-ID: <3761484C.75267E6@trw.com>


You have probably already checked this, but it your cron up and running? ps -ef | grep cron

Later!

Brian Peasland wrote:

> I've been trying to create a script which I'll be executing through cron.
> When I run the script, everything works just fine. When I schedule the
> script through crontab, it doesn't work. And I can't see what the cron
> script is doing. Any ideas how to find out the "output" from the run of a
> cron script?
>
> Here's what I'm trying to do:
> in a script,
> change SID
> sqlplus userid @script < passwordfile
> mail results
> do again for another SID
>
> The script contains a spool command to spool the results of the script to a
> file. That file is sent to my email account. When I run this script through
> the command line, it works just fine. When I run it through crontab, the
> spool file is empty and I get mailed nothing. Any ideas?
>
> Thanks in advance,
> Brian Peasland
> peasland_at_msn.com
Received on Fri Jun 11 1999 - 12:33:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US