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

Advertisements

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

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