CRON_DATE function?

Follow

Permanently deleted user

• December 27, 2016 12:57

Looking to create a "next run" date stamp by parsing out the scheduler's CRON syntax from the My SQL Job Scheduler. 

I've gone ahead and used the work that was done in Scheduler Prep from HUM and at least translated some of the components out but looks like may have to resort to creating a Java plugin.

What I was wanting to know if there was already a 'reverse' of the existing CRON_MATCHER function

• CRON_MATCHER Checks if the given date matches the given cron expression.

0

• 

  Gido

  • December 27, 2016 13:48

  Hello Jeff, 

  Currently there is no reverse function to CRON_MATCHER available. 

  After a short research it seems that such a function could be implemented by using our Plug-in SDK following the documentation for Building Custom Functions and the two following approaches: 

  • Convert Cron Expression to Date or Time
  • Cron Expression Parsing into Java Date

  1

  Comment actions Permalink
• 

  Permanently deleted user

  • December 27, 2016 13:55

  Thanks Gido, Figured as such but thought I'd inquire.

  0

  Comment actions Permalink

Please sign in to leave a comment.