Focal Point
[SOLVED] Control-M execution of ReportCaster schedules

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6881015632

July 11, 2007, 01:04 PM
BobSh
[SOLVED] Control-M execution of ReportCaster schedules
I read a previous posting regarding Control-M (CM) but that didn't address my problem. CM is a scheduling tool. I am having it call a fex called rc_exec that has the DSTRUN logic including schedule ID, job description, and owner. The RC schedule executes via DSTRUN correctly. We have dependencies in CM that execute schedule 1 before schedule 2 and so on. We don't want schedule 2 to execute until schedule 1 has completed in RC. That's the problem. When rc_exec submits the RC schedule it immediately sends a return code = 0 if it submitted OK. CM does not know when RC has actually finished running the job. We considered a post-process to create a trigger file but we have over 300 schedules and this does not seem a very elegant solution. Does anyone have experience either with CM or another scheduling tool executing schedules in RC and knowing when the RC schedule has completed?

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.7.05M, gen 144, Windows 2008 Server R2 64-bit, Tomcat 6.0.33, IIS 7.0, SQL Server, Excel 2013, PDF, HTML, FOCUS files.
July 11, 2007, 01:41 PM
Prarie
That was the only way we could figure out to do it ...We had a basic Fex that created the trigger word...that Control-M was looking for...and put it as an -INCLUDE in each procedure. If someone else knows a way...I'd be interested.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
I am having a conference call with IBI tomorrow to discuss this. I'll let you know what comes out of it.


WebFOCUS 7.7.05M, gen 144, Windows 2008 Server R2 64-bit, Tomcat 6.0.33, IIS 7.0, SQL Server, Excel 2013, PDF, HTML, FOCUS files.
Thanks. Smiler


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
I did a presentation at Summit of how we have integrated ReportCaster and Control-M. Let me know if you're interested to have more information about it.


WebFOCUS 7.7.05M, gen 144, Windows 2008 Server R2 64-bit, Tomcat 6.0.33, IIS 7.0, SQL Server, Excel 2013, PDF, HTML, FOCUS files.
Hmmmm missed that one while there. We have a pretty good Solution working here now. Thanks for the update.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
Hi,

We do have a Control-M as our scheduling tool and I am in the process of analyzing the Reportcaster with Control-M and didn't succeed on it. If you share your presentation and the way to achieve this, would be great.

Thanks


WFConsultant

WF 8105M on Win7/Tomcat
Did you get the information from Terry or do you still need it?


WebFOCUS 7.7.05M, gen 144, Windows 2008 Server R2 64-bit, Tomcat 6.0.33, IIS 7.0, SQL Server, Excel 2013, PDF, HTML, FOCUS files.
didn't get any information. Yes I do need it.


WFConsultant

WF 8105M on Win7/Tomcat
Send me your email address and I'll send the different programs/scripts. We are on UNIX. It looks like you're on Windows so you'll need to devise a similar method to what we came up with.


WebFOCUS 7.7.05M, gen 144, Windows 2008 Server R2 64-bit, Tomcat 6.0.33, IIS 7.0, SQL Server, Excel 2013, PDF, HTML, FOCUS files.
check your PM


WFConsultant

WF 8105M on Win7/Tomcat