Hello Everyone,
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.
Steps:
1.
Find
the Parent Job ID
Schema:
PTTWO3_BIPLATFORM
SELECT DISTINCT issuer, owner,
parent_job_id
FROM
xmlp_sched_job
WHERE
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.
delete from
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. !!
Regards
Jethin Abraham