Write 3 cron jobs for mac (using anacron?)

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

Taidot: Mac OS, Python, SQL

Näytä lisää: ubuntu anacron, anacrontab syntax, anacron every minute, anacron daemon, ubuntu setup cron job command line, anacron list jobs, anacron examples, anacron hourly, setup cron jobs using curl, limiting cron jobs direct admin, free webspace php cron jobs php imap, cron jobs directadmin, rets cron jobs, adding cron jobs direct admin cgi, upload photo mac using file, directadmin cron jobs, cron jobs symfony, write code intrusion detection prevention using windows, set cron jobs phplist, boonex cron jobs

Tietoa työnantajasta:
( 10 arvostelua ) Brooklyn, United States

Projektin tunnus: #15907270

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi, macOS has built in service for that — launchd. Not sure about b) — you need to save data described with INSERT/UPDATE?

$30 USD 1 päivässä
(3 arvostelua)

Hi What database and version is running in the server? Wouldn’t be better to do an export or dump in the remote server and then scp data back to your computer? This way you would save bandwidth, time and avoid missing Lisää

$30 USD 2 päivässä
(0 arvostelua)