Scheduled Job Still Running even though its deleted and not in Managed Jobs

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

Labels: , , , ,