We have users receiving emails for scheduled reports. However, we cannot seem to find where they are coming from in the Report Scheduler.
Is there a database table we can query or delete from for these schedules?
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;
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.