I need help writing 3 cron jobs for a mac. If a cron is missed due to the computer being shut off, the cron should run as soon as possible (ie as soon as mac is turned on).
Crons 1 & 2 are simple commands that I have prepared. They should be run once weekly Sunday 12pm EST.
Cron 3 should run every 2 weeks on Sunday 12:30 pm. Basically you need to construct sql queries for me. The cron should:
a) extract all data older than 4 weeks old from 2 of my sql tables located on a remote server.
b) It should then save that data to my mac (in .sql format)
c) then delete that data from the 2 sql db tables on remote server