Focal Point
Report Caster - Log with List of Report???

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

June 02, 2008, 02:43 PM
Latigresa
Report Caster - Log with List of Report???
Does anyone know if Report Caster keeps a log of all the Reports it has scheduled with the fex name, time and fruequency? If it does where is that located?

Thank you for all your help in advance,
Ana


WEBFOCUS 7.6.4
Server: WINXP
June 02, 2008, 04:52 PM
GinnyJakes
BOTSCHED contains a list of all the existing schedules. It can be joined to BOTTASK which would contain the tasks including the fex name.

BOTLOG and BOTLOG2 contain the log of executed schedules. These files are purge on a routing basis. You would have to do string searches on BOTLOG2 to get the information that you needed.

You can create synonyms for these tables by going to the adapter entry for the RC repository and choose Create Synonym. Then you can write reports.

These masters are doc'd in the rcadmin manual which you can download from the website.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
June 02, 2008, 04:55 PM
Latigresa
Thanks!!! I will download the manual and read up on it...

Thank you so much for your help!!! :-)

Ana


WEBFOCUS 7.6.4
Server: WINXP