The user trying to delete / remove the job is not the owner of the job.
Only the job's owner can alter the job, force the job to
run, or remove the job from the queue.
SolutionTo implement the solution, please execute the following steps:
1. Determine the owner of the job with the query shown below
SQL> select job, what, log_user, priv_user from dba_jobs where job=<job_number> ;
2. Connect to the database using SQL*Plus as the owner of the job (value of priv_user from the
query results obtained in step 1)
3. Execute the job removal procedure and commit the transaction.
SQL> exec DBMS_JOB.remove(<job_number>) ;
SQL> commit;