A Clarity job is stuck in a Processing state for a long time. Jobs have been canceled and deleted from the UI but the newly run job goes into Waiting status. This issue can happen with any job.
|
|
Other jobs of different types may or may not be running.
Identify which symptom applies to you to implement the appropriate solution. There are three possible scenarios noted below:
select * from CMN_SCH_JOB_CURR_RUNS where job_definition_id != -1
Delete from CMN_SCH_JOB_CURR_RUNS where job_definition_id != -1;
Commit
Keep in mind that some jobs such as Time Slicing during rollover could take a long time and this can be normal. They can appear to be Processing in UI for too long and truly be processing. Please see: Times Slicing job: Check the status / estimated completion time