Schedule according to db calendar

[ahmadhw]

Is it doable to schedule my workflow according to specific datetime column in database table ?

Redshift database > calendar_table > due_datetime_column

example:

2024-01-01  

2024-01-08

2024-01-10

2024-02-06

etc...

no pattern on the dates 

[ArtApa]

@ahmadhw - I would create a simple workflow that would read your db and compare values in db against the current date. Then, if TRUE, would trigger the required workflow via API.

Alternatively, you can create a workflow that will create schedules based on values in the table leveraging API V3 (POST /v3/schedules).

Hope that helps.

[jandalgaard]

You could make use of control containers... 

Schedule your workflow daily. If your date-table contains todays date, the following containers will be executed.

.

[ahmadhw]

this gonna work on alteryx gallery as custom schedule, right ?

[ahmadhw]

Great Great idea actually, I will use it as plan B, But I wish I can do that in custom dates only on alteryx server (Gallery)