Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Report Caster control job calls another control job

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Report Caster control job calls another control job
 Login/Join
 
Sophie
Silver Member
posted
Hi,
Is it possible to call a control job from a scheduled Report Caster control job?
Thanks
Sophie


WebFOCUS 5.2 upgrading to the latest version at the moment.
UNIX
HTML
 
Posts: 35 | Registered: September 16, 2009Report This Post
harsha.g
Member
posted Hide Post
I assume that "control job" you means is nothing but one fex procedure. And you can invoke any procedure from a scheduled report caster job just by calling that procedure under "Post-processing Procedures".


Version: WebFOCUS 7.6.6
O.S. WebFOCUS is mounted on Unix
Output Report: HTML, Excel, CSV, PDF and TXT
 
Posts: 14 | Registered: November 24, 2008Report This Post
jgelona
Master
posted Hide Post
Also check out DSTRUN.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
Sophie
Silver Member
posted Hide Post
Hi,

Yes, it's a fex procedure scheduled on Report Caster which call other jobs within it.

Normally, it run successfully when calling a 'normal' job. However, when calling another control job (which has its own 'child jobs' within it), the 'sub' control job failed to run but all other 'normal' jobs run successfully within the first control job.

Hope I make myself clear here
Thanks


WebFOCUS 5.2 upgrading to the latest version at the moment.
UNIX
HTML
 
Posts: 35 | Registered: September 16, 2009Report This Post
harsha.g
Member
posted Hide Post
This is what I understand from your comments. So let’s say you have Job1 which is scheduled in Report Caster. Job1 in turn calls say: Job2, Job3 and Job4.Lets say Job2 and Job3 are normal jobs (Meaning, these jobs do not further INCLUDE or EXecute any other fex procedures) and lets say Job4 is a control job (Meaning, it in turn calls Job5 either by INCLUDE or EX command).

Now, the problem you are facing could be that when Job1 is executed by Report Caster, the Jobs: Job2 and Job3 are completing successfully and where as the Job5 (called with in Job4) is failing. Correct?

If the above scenario is what you are facing then answer the below questions:
1) What is the error message you are getting?
2) If you are running Job4 stand-alone from DevStudio, is the Job5 completing successfully?
3) Did you tried to run just the Job4 from Report Caster and is that completing successfully?

If the scenario that I have mentioned above is not correct then please try to provide such scenario.


Version: WebFOCUS 7.6.6
O.S. WebFOCUS is mounted on Unix
Output Report: HTML, Excel, CSV, PDF and TXT
 
Posts: 14 | Registered: November 24, 2008Report This Post
Sophie
Silver Member
posted Hide Post
Hi, thanks for the respond.

Yes, the scenario is similar to what was described.

There is no error message. The primary Control Job log showed that it run sucessfully with no error. However, the 'child' jobs within the sub control job didnot run.

We resubmitted the sub Control Job (stand-alone), and it run sucessfully.

Thanks


WebFOCUS 5.2 upgrading to the latest version at the moment.
UNIX
HTML
 
Posts: 35 | Registered: September 16, 2009Report This Post
Tony A
Expert
posted Hide Post
Sohpie,

Run the main job from RC manually but choose to have traces turned on. The traces can be located (default) in [install drive:\dir]\ibi\reportcaster76\trc. choose tyo trace both schedule and fex.

These may or may not tell you what is being run but the fex that is run by RC will be shown within the trace folder and you might be able to see if there are any anomolies etc.

If you still can't fathom it out then why not set (using harsha's scenario abpve) Job4 to kick off a scheduled job (set as "run once") by setting the next runtime to a time a fex minutes in the future (see Jodye Yates' excellent article).

Good luck

T

For everyone, don't forget that there are many tips and techniques available from the Developer Centre )see link top left), that may be able to spawn ideas on how to overcome your individual problem. Just keep an open mind on the way forward.


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Report Caster control job calls another control job

Copyright © 1996-2020 Information Builders