Deletion of scheduler stuck on deleting from JobRun_PredJobRun, how can we check the progress?

book

Article ID: 221520

calendar_today

Updated On:

Products

Automic Automation Intelligence

Issue/Introduction

Deletion of scheduler stuck on deleting from JobRun_PredJobRun, how can we check the progress?

INFO [DeleteSchedulerHelper] Step 3>Deleting JobRunPredJobRun

Environment

Release : 6.3.0

Component :

Resolution

The JobRun_PredJobRun table can have a lot of rows and can take time in some environments.

 

There should be some logging in the jaws.log like below:

[QueryTimingService] 102.2% of last 0:01:00 spent in DB/API operations (possibly on multiple threads/overlapping queries) 79.1%: 27x (avg. time: 1.76) flush 8.1%: 4,098x (avg. time: 0.001) query: delete from JobRun where id = :id 4.4%: 4,098x (avg. time: 0.001) sql: DELETE FROM JobRun_PredJobRun WHERE predJobRunId = ? 3.3%: 4,098x (avg. time: 0) sql: DELETE FROM JobRun_PredJobRun WHERE jobRunId = ?

 

To verify how many rows are still in that table you can run a query like below using your scheduler name:

select s.schedulerName, count(*)
from JobRun_PredJobRun jrpjr, JobRun jr, JobScheduler s
where jrpjr.jobRunId = jr.jobRunId
and jr.jobSchedulerId = s.jobSchedulerId
and s.schedulerName = 'SCHEDULER_NAME'
group by s.schedulerName

 

You can run this query to get a count of the number of rows, and run it again later to verify if you are seeing the number of rows drop, if so, it is still making progress and may take time to complete.