mysql - How to have a Shell script continue after reboot?

Question

I have a Shell script that needs to run in a loop, and perform a series of commands, and when it's finished repeat, hence the loop. Between each command there is a sleep command for a few minutes. The "job" should never terminate. I can have the script start a boot time, but it needs to continue where it left off in the sequence for the commands when the system is rebooted.

How can I best accomplished this? Should I create a MySQL table of the queue of commands, and have it delete each row after each time it successfully executes it? Then when it completes the loops it would re-populate the queue table and start from the top.

It seems like I'm missing something to make this more simple. Thanks in advance for your helpful insight!

Answer 1

You may want to rewrite your code so that it looks like this:

while: ; do
    case $step in
        0) command_1 && ((step++)) ;;
        1) command_2 && ((step++)) ;;
        ...
        9) command_9 && step=0 ;;
        *) echo "ERROR" >&2 ; exit 1 ;;
    esac
done

So you would be aware of what has been done by testing the value of step.

Then, you may want to set a trap before the while loop is executed, so that, on exit, the value of step is written to a log file:

trap "echo step=$step > log_file" EXIT

Then, all you need to do is to source the log file at the beginning of the script, and the last one will continue its job where it has been stopped.