SDI Execute Sequential Flowgraphs

[Former Member]

Hi,

I am trying to find a way to execute a flowgraph just after another one has finished, but I don't find where I can link this two flowgraphs with the SDI.

As the flowgraphs can be stored and called as a stored procedures, I was thinking to implement another procedure that calls this two flowgraphs sequentially, but i am not sure if this is the best option.

Is there any way or workaround out there?

Many thanks in advance.

Example:

1. Execute Flowgraph1
2. Flowgraph1 finish and triggers the execution of Flowgraph2
3. Execute Flowgraph2
4. Flowgraph2 finish

[AmericoFlores]

Hello

I have a similar problem but the flowgraphs are in different containers, I try to grant privileges on the schema container to the parent schema (PS_DB) where the stored procedures are but no success.

Thanks in advance.

[Former Member]

Solution ? i have same problem

[former_member486160]

Execute flow graph using stored procedure. In that SP you can specify flow graph in sequential order.