topic Re: Schedule according to db calendar in Alteryx Server Discussions

Schedule according to db calendar

ahmadhw — Mon, 08 Jan 2024 15:47:41 GMT

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

Re: Schedule according to db calendar

ArtApa — Tue, 09 Jan 2024 06:03:38 GMT

@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.

Re: Schedule according to db calendar

jandalgaard — Tue, 09 Jan 2024 07:55:06 GMT

You could make use of control containers...

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

Re: Schedule according to db calendar

ahmadhw — Tue, 09 Jan 2024 12:31:35 GMT

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

Re: Schedule according to db calendar

ahmadhw — Tue, 09 Jan 2024 12:34:08 GMT

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)