Scheduling Workflows in Win 2K Advances Server

[ACool]

Hi,

We are running Informatica 6 on Windows 2000 Adv Server. I have a small query regarding scheduling of workflows.

How do we schedule the execution of the workflows in sequence in Windows? I understand this can be achieved in UNIX easily.

Our DW structure is as follows:

Source --> Staging Area --> Data Warehouse --> Data Mart

We want the loading to occur as shown above.

Presently we have 3 separate workflows which we want to schedule one after the other.

We DO NOT want to combine these into a single workflow since it would not be in the interest of scalability (also readability ) as several more data marts are envisaged in the future.

Please send a reply to my id too.

Thanks,
Asif

 

[srpvc]

It Can be an idea rather than solution to your problem.
Create one file tmp_To_Raise_Event.ind manually.
In your first workflow at the end add one command task.
give command as
copy tmp_To_Raise_Event.ind workflow_finished.ind

And in second workflow
add Event Wait task with Predifined option and filename as workflow_finished.ind

and do same steps for rest of workflow...
I am pretty much sure this one will give you solution

-Venkat