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

Hello Everyone,

 

Scenario

I got a request to add a user to a distribution list for a scheduled BI Publisher job which runs every day at 9:00 am. When I went looking for the job in Report Job section it wasn’t there. However when I went to Report History section I could see the jobs were running successfully.

Reason

After talking to Oracle it seems that its a bug in BI Publisher. If a report job was created by User A and then deleted by User B it gets deleted from the UI but the underlying tables still have the information.

 

Oracle provided a solution to resolve 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 fromQRTZ_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

One thought on “Scheduled Job Still Running even though its deleted and not in Managed Jobs

  1. HI Jethin. Do you know if this issue is actually fixed in any later versions after 11.1.1.7 OBIEE
    Thanks Nicolai

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s