% and crontab

Crontab is a wonderful tool to run tasks at scheduled times. I noticed that my cron jobs fail if I use the percentage sign (%) in it. Why? It works if I just execute the command in my shell.
echo $(date +"%Y%m%d")

Ok, is the crontab using a different shell? Yes it is! Let’s try setting crontab to use the shell I want. This can be done by adding the path of my shell to it:
crontab -e

(Of course I could have switched to /bin/sh and executed the command from there)
Still no luck. Interesting…

Ok, let’s see what the manual says

Percent-signs (%) in the command, unless escaped with backslash (\), will be changed into newline characters, and all data after the first % will be sent to the command as standard input.

Wait a minute, that’s it. I escaped all % signs and my crontab’s started to work, yay!
30 * * * * /usr/local/bin/iocage snapshot sql -n $(date +"\%Y\%m\%d")
This command creates ZFS snapshots of the jail called sql every hour at the 30th minute.

Lesson learned: % signs must be escaped in crontabs! For example if you specify date format in crontab add a \ in front of %.

Side note: one must use proper SQL backup tools, not just ZFS snapshots.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.