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;
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