Write 3 cron jobs for mac (using anacron?)

$10-30 USD

Stengt

Lagt ut

over 6 år siden

$10-30 USD

Betalt ved levering

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

Mac OS

Python

SQL

Prosjekt-ID: 15907270

Om prosjektet

2 forslag

Eksternt prosjekt

Aktiv 6 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

2 frilansere byr i gjennomsnitt $30 USD for denne jobben

@pakulin

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

$30 USD om 1 dag

4,8

(3 omtaler)

2,3

@marcelofreelance

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 backups as you can transfer everything from a remote directory to your computer and delete the remote copy. What OS and version is the remote server? Regards

$30 USD om 2 dager