Cannot find report schedules in the report scheduler

Document ID : KB000015880
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

We have users receiving emails for scheduled reports. However, we cannot seem to find where they are coming from in the Report Scheduler.

Question:

Is there a database table we can query or delete from for these schedules?

Environment:
UIM 8.5.1cabi probe 3.0wasp 8.5.1Jaspersoft 6.3
Answer:

Review these tables: UMPSCHEDULE and UMPJOB 

SELECT * FROM UMPSCHEDULE SCHED INNER JOIN UMPJOB JOB ON SCHED.JOB = JOB.ID; 

Please be sure to backup your database and use caution when deleting from these tables so as not to delete wanted schedules. 

DELETE FROM UMPSCHEDULE; 

DELETE FROM UMPJOB; 

 

 

Additional Information:

Other CA products that use jaspersoft / CABI may store the Report Schedules in different tables.

This query may also be helpful:

SELECT * FROM JIREPORTJOB JOB 

INNER JOIN JIREPORTJOBTRIGGER TRIG 

ON JOB.JOB_TRIGGER = TRIG.ID 

INNER JOIN JIREPORTJOBOUTPUTFORMAT OUTPUT 

ON OUTPUT.REPORT_JOB_ID = JOB.ID 

INNER JOIN JIUSER USR 

ON USR.ID = JOB.OWNER 

INNER JOIN JIREPORTJOBREPODEST DEST 

ON DEST.ID = JOB.CONTENT_DESTINATION 

INNER JOIN JIREPORTJOBMAIL EMAIL 

ON EMAIL.ID = JOB.MAIL_NOTIFICATION 

 

It would be safest to delete these in the Jaspersoft UI. 

The REPORT_UNIT_URI and FOLDER_URI columns should show where the report schedules are.