#!/bin/sh
sqlplus -s scott/tiger <<!

update Parking
set wheels = 4
where vehicle = 'car' ;

select * from Parking;
!

This is the script I had written for updating a table called "Parking". It executes properly when I run it from the command line. But , when I try to do the same thing as a cronjob it just tells me that "sqlplus not found"

syntax that I gave in the cron file:
50 01 07 04 04 /personal/users/sa/Mani44.sh > /personal/users/sa/tot.txt 2>&1

I saved the script in the file Mani44.sh

Please help me out

Question:

Are you running the cron with same login id.?

It seems environment is not set properly in the cron script.

export all the necessary env variables such as PATH to run the script successfully as cron.
OR
If environment is set in user1's .profile set the cron as follows.

for more help

man su