Run Multiple Workflows Simultaneously After Main Workflow Runs
- 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
Let's say I have Workflow A which creates Table A. Then I want to run 10 workflows at the same time immediately after Workflow A in which each of these subsequent workflows would use Table A to join up its own unique data source. So the idea would be to save time in lieu of having one workflow having to wait for each input tool to extract the data.
I would want this to be scheduled on the server which prevents me from using CREW macros.
I also don't believe chained analytic apps would be useful since I want these workflows to run at the same time.
Is there any way it's possible to do this? I recall at the conference last year there would be sequencing schedules in future releases that I think would apply in my situation but I haven't seen anything like that yet.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A few thoughts:
1. CReW macros run on the server.
2. There are physical limits to running to many jobs concurrently.
3. If 10 jobs read table A, it is likely more performant to run 1 job that reads it and to perform 10 writes.
especially when table a is huge, read it once and join away.
cheers,
mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
