Help me with crontab

rmard · #1 (**permalink**) 02-07-2008

Hi,

I am working with oracle, and want to make a scheduler program by using cron job..

I've done with shell script that calls oracle stored procedure. It works.

However, when I call the script through crontab, it is failed.

Here is the error message:

Code:

Cron: The previous message is the standard output
      and standard error of one of your crontab commands:

sh /app/bea/report/script.sh


From root@icaredv1 Wed Feb  6 17:22:00 WIB 2008
Received: (from root@localhost)
	by icaredv1 (8.11.1/8.11.1) id m170M0v06352
	for acn01; Wed, 6 Feb 2008 17:22:00 -0700 (WIB)
Date: Wed, 6 Feb 2008 17:22:00 -0700 (WIB)
From: root@icaredv1
Message-Id: <200802070022.m170M0v06352@icaredv1>
Subject: cron

/app/bea/report/script.sh[3]: sqlplus:  not found.


*************************************************
Cron: The previous message is the standard output
      and standard error of one of your crontab commands:

sh /app/bea/report/script.sh

I've check whether I missed something with my cron file. But, when I use other shell script for cron, it works.

Please anyone help me. Thank you..

GaneshB · #2 (**permalink**) 02-08-2008

Hi ,
u need to define Env . Varibles .
Here i think you did not define the Env .veriables , hence the cron is not able to locate 'sqlplus' . pls change it ..it will work .

Smiling Dragon · #3 (**permalink**) 02-10-2008

As GaneshB hints, cron doesn't set any environment variables. Add a step to the start of your script that picks up the user's profile again or create a wrapper script to do this.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
crontab couldn't run through, help	duke0001	UNIX for Advanced & Expert Users	10	02-06-2008 03:22 AM
help with crontab	bob122480	Shell Programming and Scripting	3	01-22-2007 08:49 PM
Crontab	gen4ik	UNIX for Dummies Questions & Answers	1	01-18-2007 07:26 AM
ftp and crontab	user`	Shell Programming and Scripting	27	11-13-2006 08:02 PM
Crontab	lo-lp-kl	UNIX for Dummies Questions & Answers	2	05-05-2005 07:21 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by