Is there a way to export a list of all enabled schedules ? I have admin rights.
ThanksThis 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