Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cron scripts
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