Focal Point
Start a flow from a different reporting server

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/999103163

February 04, 2010, 12:15 PM
ShawnS
Start a flow from a different reporting server
I am looking to execute a foreign flow on a foreign reporting server to run within that reporting server.

I have played with the CMRUN enough to find out that it actually runs the foreign flow from the reporting server that originates the CMRUN command. This leaves me without a flow log on the foreign server.

The situation is I have a DM reporting server on USS z/os (v7.11) and another one on windows (v7.6.10). We want to start creating new flows on the windows DM reporting server that trigger after the completion of flows that run currently on the z/os box.

In the past when encountered with similar issues I would have the z/os ETL update a reportcaster repository which would fire off a webfocus job. However, the DM's scheduler doesn't work in the same manner. I have even tried to remotely edit the DM_SCHDCODE variable in a flow, but the fex is slash delimited which made typical updates, modify's, or -WRITES complicated at best.

Is there any way to achieve this?


wf 767 running on w2k3 srvr
February 05, 2010, 07:27 AM
Jessica Bottone
Can you FTP a file from the z/os to the windows server when the z/os flows are done? If so, check out case number 31732547. Not exactly the same as your situation but I think you could apply the technique.


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
February 09, 2010, 09:05 AM
ShawnS
Thanks Jessica. That is an interesting alternative, but I don't know how confident I am in the sleep function. I am going to play with it for other things.

I did find a solution in running a sql server stored procedure using xp_cmdshell. That runs a .bat file which contains the cmrun. Somewhat sketchy, but least painful of the two.

Thanks


wf 767 running on w2k3 srvr