Focal Point
[SOLVED] Report Caster List

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

November 17, 2015, 10:09 AM
JOE
[SOLVED] Report Caster List
Is there a way to export a list of all enabled schedules ? I have admin rights.

Thanks

This message has been edited. Last edited by: Tamra,


WebFocus 7.7.02 WinXP
November 17, 2015, 12:42 PM
prodrigu
JOE,

You can create a report to see all ACTIVE report caster jobs. There are tables that have all the information you are looking for. Below is an example.

TABLES: BOTSCHED, BOTTASK, BOTDEST


  
JOIN BOTSCHED.BOTSCHED.PACKETID IN BOTSCHED TO ALL BOTTASK.BOTTASK.PACKETID IN BOTTASK TAG J0 AS J0

DEFINE FILE BOTSCHED
METHOD/A10 = IF (METHOD_CODE EQ 'M') THEN 'Email' ELSE
             IF (METHOD_CODE EQ 'P') THEN 'Printer' ELSE 'Other';
LIST_T/A25 = IF (LISTTYPE EQ 'D')    THEN 'Distribution List' ELSE
             IF (LISTTYPE EQ 'S')    THEN 'Single Email Address(es)' ELSE 'Other';
END

TABLE FILE BOTSCHED
PRINT
LISTTYPE
COMPUTE LIST_TYPE/A25  = IF SCHEDULEID EQ LAST SCHEDULEID THEN '' ELSE LIST_T;
COMPUTE DIST_LIST/A800 = IF SCHEDULEID EQ LAST SCHEDULEID THEN '' ELSE DISTLIST;
BY JOBDESC
BY SCHEDULEID
BY CASTER_USER
BY ACTIVE
BY METHOD
BY MAILSUBJECT
BY TASKNAME
BY TASKOBJ
WHERE CASTER_USER IN ('wmgbatch'); -- YOU CAN LIMIT WHAT FOLDER YOU WANT TO SEE ACTIVE JOBS OR SEE ALL ACTIVE JOBS
WHERE ACTIVE EQ 'Y';
ON TABLE HOLD AS RC_INFO
END
-RUN



Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats