Hi, I need to write a cron job script which automatically updates the values in the databse without anyone's intervention. I am pretty new to this concept and I have got no idea of how to write a script of cron job.
Write your database update as a regular script (which, of course can call other java programs to actually to do the update or use something like isql) and then all you use cron for is to schedule the execution of that script. Once you have your script written, it is a simple step to add it to cron. Take a look at the man pages for cron or ask your sysadmin. [ January 10, 2006: Message edited by: Don Morgan ]
The "script" does not have to be a shell script. It can be any executable program written in any language that you choose. cron just schedules when it should be run. I think you could make it as a Java application. The only caveat I can see is that cron might not like running something like "java MyApp", so you may need a shell script with just one line to launch your Java app.