I have to figure out a way to automate a daily process flow in Data Migrator. I know the flow can be automated by setting a scheduled time and date, but that won't suffice since our initial processes, before the flow, finish at random times. Is there a way a process flow can get automated other then through a times schedule? I am looking at possibly just creating a script that will capture an email, variable, file, etc... that will trigger Data Migrator to process the flow file.

This message has been edited. Last edited by: <Emily McAllister>,

Have you looked into multple tasks within a single ReportCaster job? That may be a solution for you.

Let me add that the initial processes before the process flow are outside WebFocus. I am waiting for a process to end in AS400 before I can run the process flow in Data Migrator.

Just thinking out loud... Perhaps you can add a "finished" message (text file on a server) at the end of your AS400 job which can be read in a pre-process task in your RC job.

Open a case and get the CMRUN program for AS400. It is basically a client to allow you to run a iDM process flow from a remote process/server/whatever. I assume the 400 stuff is running using a scheduler, just make the CMRUN a dependant event for the current process.

We have several processes on AS400 that run in some kind of queue on that machine. Perhaps that's how your process works as well?

The thing is, the queued task and it's current status are kept in a table (as I understand it, nearly everything on AS400 is in a table of some sort). That table is accessible by WebFOCUS!

What we did here is fire the processing task from ReportCaster on a scheduled time, but we start that task with reading the queue status of the AS400 task. If the task did not finish yet, we SLEEP 10 and retry.

Yup, that's a polling loop.