Trigger Scheduled Job intervals cron config information

💬 Workflows
1

Hello,

is it possible to extract information about a scheduled job intervals cron config?

My understanding is that generally is not "reliable" in terms of compatibility to rely on information like workflowcontext last/current/last-successful run timestamps. Avoid to use those info to build workflows that extract data using last/current/last-successful timestamps as time window for polling/ingesting from a DB resource. e.g.

select * from table where lastmodfied date is between last-successful-run and now

So we have implemented an external table that keep track of the launches and uses the time stamp for scheduled workflows. But the calculations may need to know in advance the job interval info e.g. every minute every hour etc etc, so to be flexible and we can change the trigger config without touching the workflow code that will adapt automatically.

Thank you

3

Hey @dda - thanks for reaching out. While not super intuitive, the only option that comes to mind for dynamically pulling info about a workflow's schedule is to use the Retool API. It might require some nasty parsing to specifically implement what you're describing, but it should technically work.

4

Let if me know if you've had a chance to revisit this and have any additional questions, @dda!