You can write a simple shell script which performs the sqoop import and run the shell script using a cronjob on a timely basis.
Below link gives different examples on how to run a cron job
Ex: You can put the shell script in /etc/cron.daily and run
crontab -e 0 1 * * * <path to script> ----> run every day at 1 AM
If you feel that cron is complex then I would suggest jenkins which most of the people use for CI . It has a nice UI where you have an option of doing periodic build. Just create a small job in jenkins. Add option "Build periodically" and give the cron expression to build each day. You can find cron expression easily by googling. And the build step would be only to call the script which you have written.
You can also use python/perl or any other scripting languages if you are not used to shell scripting. Even from jenkins or crontab your job is only to call the script which you have written.
Hope this helps 🙂
You already have a script created sample.sh ,Now save it in some directory like /home/devi/sample.sh make sure the file is executable then the entry in the crontab should be like below
invoke the crontab in edit mode
# crontab -e
Paste your code
0 1 * * * /home/devi/sample.sh ----> run every day at 1 AM
save the file
You can adjust the test by changing the time to every 2 minute
*/2 * * * * /home/devi/sample.sh ----> run every 2 minutes
There are many online sources that can help