I was going through scheduling a BIP job and later deleted it and still the job was running and failed because of no report in the path.
When I went to Report History I could not find the deleted job. After talking to Oracle it seems that its a bug in BI Publisher. Please find the alternative approach to this issue.
the Parent Job ID
SELECT DISTINCT issuer, owner,
user_job_name LIKE 'Report Name'
AND parent_job_id is not null.
2. Purge the hobs in the following order from the Quartz tables.
QRTZ_CRON_TRIGGERS where trigger_name = 1234;
delete from QRTZ_TRIGGERS where trigger_name = 1234;
delete from QRTZ_JOB_DETAILS where job_name = 1234;
You should be good to go. !!
Labels: BIP, BIP DELETED SCHEDULED REPORTS ARE NO LONGER SHOWN IN MANAGE REPORT JOBS, Job deleted, SCHEDULE JOB STILL SENDING NOTIFICATION HOWEVER NOT LISTED UNDER:REPORT JOB, Scheduler