 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Report Caster Schedule | Login/Join |
| Member |
Is there a method to cause a report caster schedule to run outside of the normal timed schedule? I run SQL Server and when a SQL Server Job step is complete, I would like it to start a schedule in report caster so that the report would be delivered as soon as possible.This message has been edited. Last edited by: <Kathryn Henning>, WebFOCUS 8.0 | ||
|
| Silver Member |
I had a similar situation where accounting was always contacting us to rerun reports generated from report caster at month end. The problem was we were never quite sure when they would request this or when we could get around to running it for them. To resolve this i created a SQL table RUNREPORT that is keyed by the report name that contains a flag to run the report if set to 1. I then built front ends in html for the reports that basically all they do is set the flag. In report caster I created a job that runs every 15 minutes and checks the flag. If set to 1 it runs the report and changes the flag back to 0. If the flag is 0 it just drops out. So if you able to set the flag when the Server Job is complete it would work. It's not a perfect solution but at least the user knows they will have the report within 15 minutes and it works. Hope this helps. WebFOCUS 7.7.03 Windows all output (Excel, HTML, PDF) | |||
|
| Expert |
yep. i agree w/ Glenn. we use a PRE-PROCESSING fex (you know how to do that? edit schedule, tasks, click on task and click edit, advanced button, procedures tab, then enter the name of the fex you want run BEFORE the job). In this little pre-processing fex (sitting in the same app directory), you test whatever status condition you want and if you get a no-go condition then you -SET &&KILL_RPC = 'Y' ; and that's it, the job won't run 'N' is the default you can specificaly set -SET &&KILL_RPC='N' if you want, when you get a GO condition, and your job will run like normal. (see page 140 in the WF Keysheet for syntax of the KILL_RPC command)
| |||||
|
| Expert |
Can you get SQL Server to execute a BAT file (Windows server) or script (on Unix) when it's done doing its thing? We have our scheduler kick off a BAT file to execute ReportCaster jobs based on the other scheduled jobs as dependencies, and it works out nicely. | |||
|
| Member |
Doug that is exactly what I want to do. What is in your .BAT file? What do you run to make the ReportCaster Job execute? Thanks for the other suggestions. Steve WebFOCUS 8.0 | |||
|
| Master |
Steve, I believe there is a requirement to what Doug is saying and that is that the SQL Server has to be on the same box as WebFOCUS. So, if it not then you heed to do what Glenn C. is saying. Scott  | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |