Solved shell script cron job not working

[spring_64]

hi all,
I have a shell script code as cron job that check the pool status and save it in a sqlite database.
when I run it from terminal. it work properly but in crontab it does't work.
The crontab:

#
SHELL=/bin/sh
PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/etc/myjob/pool
#
#minute hour    mday    month   wday    who     command
#
# get network interface traffic details
*/1    *     *    *   *   root  /usr/local/etc/myjob/pool/pool.sh

Can you help me figure out the mistake?

 

[usdmatt]

Let me guess, you have a call to the SQLite command in your script, but the script doesn't specify the full path to the command.

 

[spring_64]

Yessssss, Thanks a lot.