Write 3 cron jobs for mac (using anacron?)

$10-30 USD

Закрито

Опублікований

over 6 years ago

$10-30 USD

Оплачується при отриманні

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

ID проекту: 15907270

Про проект

2 пропозицій(-ї)

Дистанційний проект

Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

2 фрілансерів(-и) готові виконати цю роботу у середньому за $30 USD

@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 за 1 день

4,8

(3 відгуки(-ів))

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 за 2 дні(-в)