Can we schedule a report to run last Monday of the Monday and first Monday of the month only.

Navaneeth, it would be really helpful if we knew what release you were running. Please update your profile signature with your products, releases, and platform.

In release 7.6.x, there are additional scheduling options. You can download any of the Report Caster manuals and I'm pretty sure they would let you know what you can and cannot do in the scheduling area particular for your release.

I assume you are asking about Report Caster. I am on 7.13 and to do schedules like this I run the job daily and use a pre-processing fex to check for the conditions. If the conditions are not right, set &&KILL_RPC to 'Y' and the job will die. The thing to keep in mind is that if the job has multiple task, the pre-processing fex has to be linked with each task if you want all the tasks to not run. The following is sample where I want the job the run on the 3rd business day of the month.

-* File pp712.fex
-*
-* Pre-Processing for lnch712.
-*
-* Run job if the current date is the 3rd business day of the month
-*
-SET &RUNDT=DATECVT(DATEADD(DATEMOV(DATECVT(&YYMD,'I8YYMD','YYMD'),'BOM'),'BD',2),'YYMD','I8YYMD');
-IF &RUNDT EQ &YYMD THEN GOTO FINISHED;
-*
-SET &&KILL_RPC=Y;
-*
-FINISHED

As Ginny says, there more options with newer releases.

We do something similar in 5.3. You would need to run the program on days 1-7 and check DOWK for MON and on days 21-31 and check the month number and the DOWK. If you have many jobs that need this you should put it in an INCLUDE module.

Calculate the 1st and last Monday of each month in a pre-process fex.
If either condition is not met then do a
-set &&kill_rpc='y' and exit out else execute.
or....
Having 2 schedules one to run only on first monday of month else exit out, and then have different schedule to only run on the last Monday of the month but my opinion way too inefficient doing it the latter way..

Ira AIX 533 wf 537

Guys,

Sorry I could not understand your answers, it way over my head.

I will explain it again.

As per my requirement
1. I need to run the reports only on Business weekend so that it fetches me data only for that weekend. Now if I schedule a report in Report Caster , I guess it schedules only by Fiscal Calendar ( Normal Calendar) .

So how do I overcome this issue.

I have similar case where a particular report should only run on Business month end date and others on a business Year End date only.

“ Hi Gelona

In your reply you had sent me the following

-* File pp712.fex
-*
-* Pre-Processing for lnch712.
-*
-* Run job if the current date is the 3rd business day of the month
-*
-SET &RUNDT=DATECVT(DATEADD(DATEMOV(DATECVT(&YYMD,'I8YYMD','YYMD'),'BOM'),'BD',2),'YYMD','I8YYMD');
-IF &RUNDT EQ &YYMD THEN GOTO FINISHED;
-*
-SET &&KILL_RPC=Y;
-*
-FINISHED

Can you explain more on this , as it closely matches one of my requirement.

And what does the following cmd do “- set &&kill_rpc='y' ”

“

Thanking you in advance

Regards
Navaneeth

Sorr i forget to put in my Webfocus version , it is 7.1.4