In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Schedule according to db calendar

ahmadhw
7 - Meteor

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 

4 REPLIES 4
ArtApa
Alteryx
Alteryx

@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
6 - Meteoroid

You could make use of control containers... 

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

Snag_2a3a2e.png

.

ahmadhw
7 - Meteor

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

ahmadhw
7 - Meteor

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)