Write 3 cron jobs for mac (using anacron?)

$10-30 USD

Closed

Posted

over 6 years ago

$10-30 USD

Paid on delivery

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

Project ID: 15907270

About the project

2 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

2 freelancers are bidding on average $30 USD for this job

@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 in 1 day

4.8

(3 reviews)

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 in 2 days