Oracle dbms_job with invalid owner

Question

Well, a database on a customer site that has dbms_job entries, where the schema_user parameter is not valid. (This is apparently the effect of transferring the circuit from another machine using exp / imp.)

I would like to get rid of these jobs, but the standard operating procedure says that you must connect as the job owner to dbms_job.remove ().

I thought a workaround might be to create a user in this instance and then use it to delete the job.

Thoughts?

Edit: Or even as an alternative to directly editing the sys.job $ table instead of navigating through the dbms_job interface?

Answer 1

, SYS, DBMS_IJOB. , DBMS_JOB, , .

- 23, :

SQL>  exec dbms_ijob.remove(23)

, SYS . !