Shell Programming and Scripting

fixpart="/files/myScript  # Transfer Script"
  echo "Specify the transfer frequency in minutes - "
  echo "every 1, 2, 3, or 5 minutes (default every 1 minute) "
  echo  $nn "Frequency [1|2|3|5] ? [1]:" $cc
  read ans
  case $ans in
    2) echo "1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35,37,39,41,43,45,47,49,51,53,55,57,59 * * * *" $fixpart >> myCron
       break ;;
    3) echo "1,4,7,10,13,16,19,22,25,28,31,34,37,40,43,46,49,52,55,58 * * * *" $fixpart >> myCron
       break ;;
    5) echo "1,6,11,16,21,26,31,36,41,46,51,56 * * * *" $fixpart >> myCron
       break ;;
    *) echo "* * * * *" $fixpart >> myCron ;;
  esac
  echo ""
 
crontab myCron

   Contents of "/file/MyScript".
         Assumptions about the environment (cron's is different from user).
         Relative file names.
         Missing "shebang" line meaning that you use cron's default shell.
         Script asks questions when there is no terminal?
   Permissions of "/file/MyScript".
         Executable?
   Permissions of the user.
         User allowed to use cron?
   Fundamental problem.
         cron daemon not running?

echo "select empName from emp_tbl where emp_id = 5" | /usr/bin/sql emp_db 2>/usr/count_file | grep david > /usr/temp1

* * * * * /usr/sqlScript