Schedule according to db calendar
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- API
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You could make use of control containers... 
Schedule your workflow daily. If your date-table contains todays date, the following containers will be executed.
.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
this gonna work on alteryx gallery as custom schedule, right ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
