I believe it runs hourly.
After getting burnt a few times myself, I wrote MacroBackerUpper, to back up all your macros on demand (or on a schedule, if you wish). It uses a Time-Machine-like structure, with separate folders for each backup, and hard links to save disk space.
-rob.