 |
|||||
|
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. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Caster scheduling weekly as well as month start
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Caster scheduling weekly as well as month start Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED]Caster scheduling weekly as well as month start | Login/Join |
| Gold member |
Hi, How can I handle the scheduling of a report that should run every Monday morning as well as the the of the 1st of the month? Actually I have 2 schedules: 1 for every Monday, another one for month start. But I anticipate 2 reports when the 1st of the month will a Monday.... What do I have to do to control this? Any exception parameters? Need your help again, thanks. This message has been edited. Last edited by: Marikaki, Marikaki WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML | ||
|
| Expert |
Marikaki, One method that I have employed over time is to have the run dates set in a calendar file with a final step in the caster job to read the date file for the next date and then reset the nextruntime value in BOTSCHED accordingly. This would obviously require a level of maintenance but may give you a greater flexability. Another method is to use DM to calculate the BOW date and check to see if it is a Monday or the first of the month. If it is neither of these then set &KILLRPC to 'Y'. This would require that the job is run every day and might not be what you want. However, the overhead is small as the DM would be the very first part of the process to run and would be short most of the time. Just two ideas of many that you might be given. T Edited for Speel chuckingThis message has been edited. Last edited by: Tony A,
| |||||||||
|
| Master |
We use the 2nd method as described by Tony A. We have a preprocessing fex that check for the correct day to run. If it is not, we set &&KILL_RPC (2 & not one) to Y and the job stops. Also, you have to use the pre-processing fex in every task in the job (at least we do in 7.1.3) which is a pain. Hey now there's an idea. Use &KILL_RPC to kill a task and &&KILL_RPC to kill the job. Since && are globals, seems &&KILL_RPC could tell RC to flush the rest of the job and &KILL_RPC would flush the current task. In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux. | |||
|
| Expert |
Well spotted  T
| |||||||||
|
| Gold member |
Guys, because I'm very busy these days I will get back to you as soon as I can. I've read the ideas and I don't understand very well I will need more detail in a while to execute. Thank you for understanding. Marikaki WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML | |||
|
| Expert |
Very simple to understand really - -SET &DOWK = DOWK(&YYMD,'A3'); -SET &DOM = EDIT(&DMYY,'99$'); -SET &&KILLRPC = IF &DOWK NE 'MON' AND &DOM NE '01' THEN 'Y' ELSE 'N'; -? && Create a fex in your APP PATH and set it as a preprocess in your scheduled task. T
| |||||||||
|
| Guru |
Nice to know these solutions. Thanks. The dumb way I have been using is to have 2 scheduled entries, one runs every Monday, and the other runs 1st of the month. That's because I not ready to do some killing yet. Developer Studio 7.6.11 AS400 - V5R4 HTML,PDF,XLS | |||
|
| Gold member |
Great Tony! Now it is clear to me. I am not really familiar with Webfocus and this solution would not appear to me. Thank you very much. Marikaki WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML | |||
|
| Virtuoso |
 Very nice Tony! Thanks. Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2 Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K. | |||
|
| Expert |
You're all very welcome, so nice to know that three lines of DM can make people happy  T
| |||||||||
|
| Master |
Actually you can do it with 1 line of code: -* -* Run job on the 1st day of the month or every Monday -* -SET &&KILL_RPC=IF &DATED EQ 01 OR &DATEW EQ 1 THEN 'N' ELSE 'Y'; &DATED returns the 2 digit day of the month. &DATEW returns the 1 digit day of the week, 1-Mon, 2-Tues, ... 7-Sun. In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux. | |||
|
| Gold member |
Wow! We're getting more efficient! Thanks everybody. I didn't try yet, but I will as soon as I have a little moment. Marikaki WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML | |||
|
| Expert |
That cat sure is getting skinned lately  T
| |||||||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Caster scheduling weekly as well as month start
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Caster scheduling weekly as well as month startCopyright © 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 |