Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Update Next DateTime Event in MySql Table from Crontab
Sign in to Add to Watch List

IT & Programming > Web Programming

View Change History

The client has made the following changes to the job.


Job awarded.

Feb 7, 2013

Job Description

  |  Change History >>


  • Posted: Mon, Feb 04, 2013
  • Time Left: Closed
  • Location: Ireland
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: $20 - $50
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Given a table containing Crontab configurations and Date time fields, update the date time field with the next time the Crontab would be expected to fire for each entry.
The table contains crontab information in standard format e.g. 00 11,16 * * *. Iterate over the data, If the date time field is null, assume the current time and set the next occurrance in the field. If the date time field is in the past, take that as the current time and get the next time after that. If the date time is in the future, skip the update. Most of your code will be basic enough plumbing. Michael Dowling's cron library (below) should be able to handle the bulk of the cron calculations. DB format is outlined below.
Any questions please ask before you quote, don't bid unless you understand the requirement.
One well written php file that scans the table and updates as required. The php file contains m...

Sign in or Register to see more

Job ID: 37522287
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Nicky B.      
Nicky B.'s identity has been verified.  Learn More
 Ireland  |  
Irish based web designer and developer offering discounted rates to Elance customers. I create quality websites to a very high standard. I can also...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37583052  |  Submitted: Feb 6, 2013 07:50 ET 
Proposal SEALED

 India  |  
Over the last 6 years, I have been working on business as a consultant, mainly on helping new business to grow, creating business models, business...
Skills: Malwa...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37544017  |  Submitted: Feb 5, 2013 09:29 ET 
Proposal SEALED

 Australia  |  
a. Arch Linux as OS of choice. b. C/C++ programmer (with gcc, gdb, Valgrind and Vim). c. Boost Asio, threads.
 5.0   |  Private   |  1 Jobs
Bid ID: 37533640  |  Submitted: Feb 5, 2013 03:49 ET 
Within 1 day
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »