UNIX for Advanced & Expert Users

Hello!

I have a problem on adding a new crontab. Currently we have a running jobs scheduled on a crontab and they are all successfully running. However, when adding or inserting a new scheduled job, the script doesn't work. Is there any limitations on this?

Please advise.

Thank you very much.

Please paste a copy of your entry.

Hi! Here is my entry that i inserted.

* * * * * /bscsprod/bscs/prod/WORK/MP/billops/P5/p5edlin.sh > /bscsprod/bscs/prod/WORK/MP/billops/P5/prepaid_test.log

as i checked the output log, here is the message.

prepaid[7]: sqlplus: not found
last_value[7]: sqlplus: not found
status[7]: sqlplus: not found
inc[7]: sqlplus: not found
value_type[7]: sqlplus: not found
usermod[7]: sqlplus: not found
datemod[7]: sqlplus: not found
first_value[7]: sqlplus: not found

Thanks!

What happens if you run the p5edlin.sh (full path) from the command line?

Its an issue of environment (PATH, etc ...) within crontab, setting 'them' in your script (p5edlin.sh) should resolve the problem ...

Hi John,

Here is the output when running the script. Thanks.

/bscsprod/bscs/prod/WORK/MP/billops/P5:INFC $ p5edlin.sh


PREPAID STATUS INFORMATION


--------------------------------------------------------------------------| Process | Last_Value | Status | Inc | Value_Type | Usermod | Datemod | First_Value |
--------------------------------------------------------------------------
| EXTRACT_DISPATCH | 167662 | 0 | 1 | N | PREPAID | 20061206 | 20061206-24 |
=========================================================


Note: If the status is 1, inform IT for immediate backend update. Thank you!

look into this