Princeton IT ServicesResources / Blogs
Oracle dbms job remove from another schema
[vc_row][vc_column][vc_row_inner][vc_column_inner][vc_raw_html]SW4lMjB0aGUlMjBmb2xsb3dpbmclMjB1c2UlMjBjYXNlJTJDJTIwYXMlMjBzeXNkYmElMjBJJTIwYW0lMjB0cnlpbmclMjB0byUyMHJlbW92ZSUyMHRoZSUyMGpvYiUyMHRoYXQlMjBiZWxvbmdzJTIwdG8lMjBhbm90aGVyJTIwdXNlciUyMC0lMjAlMjdBTVMyMDAwJTI3JTIwdGhhdCUyMHJlc3VsdHMlMjBpbiUyMGVycm9yJTIwLSUyME9SQS0yMzQyMS4lMEElMEElM0NwJTNFQXMlMjBhJTIwc3lzZGJhJTJDJTIwd2hlbiUyMHlvdSUyMHRyeSUyMHJlbW92aW5nJTIwam9iJTIwYmVsb25naW5nJTIwdG8lMjBhbm90aGVyJTIwdXNlciUyQyUyMHlvdSUyMHdpbGwlMjBnZXQlMjBPUkEtMjM0MjElM0MlMkZwJTNFJTBBJTNDcHJlJTIwY2xhc3MlM0QlMjIlMjBsYW5ndWFnZS1ub25lJTIyJTNFJTBBJTNDY29kZSUzRSUwQVNRTCUyNmd0JTNCJTIwJTIwQkVHSU4lMjBEQk1TX0pPQi5yZW1vdmUlMjg0MDAyJTI5JTNCJTBBMiUyMCUyMEVORCUzQiUwQTMlMjAlMjAlMkYlMEFCRUdJTiUyMERCTVNfSk9CLnJlbW92ZSUyODQwMDIlMjklM0IlMEElMkElMEFFUlJPUiUyMGF0JTIwbGluZSUyMDElM0ElMEFPUkEtMjM0MjElM0ElMjBqb2IlMjBudW1iZXIlMjA0MDAyJTIwaXMlMjBub3QlMjBhJTIwam9iJTIwaW4lMjB0aGUlMjBqb2IlMjBxdWV1ZSUwQU9SQS0wNjUxMiUzQSUyMGF0JTIwJTIyU1lTLkRCTVNfU1lTX0VSUk9SJTIyJTJDJTIwbGluZSUyMDg2JTBBT1JBLTA2NTEyJTNBJTIwYXQlMjAlMjJTWVMuREJNU19JSk9CJTIyJTJDJTIwbGluZSUyMDc4MSUwQU9SQS0wNjUxMiUzQSUyMGF0JTIwJTIyU1lTLkRCTVNfSk9CJTIyJTJDJTIwbGluZSUyMDE4MCUwQU9SQS0wNjUxMiUzQSUyMGF0JTIwbGluZSUyMDElMEElM0MlMkZjb2RlJTNFJTBBJTNDJTJGcHJlJTNFJTBBJTNDcCUzRVVzaW5nJTIwZGJtc19pam9iLnJlbW92ZSUyMG9uZSUyMGNhbiUyMHJlbW92ZSUyMGpvYiUyMGJlbG9uZ2luZyUyMHRvJTIwYW5vdGhlciUyMHNjaGVtYSUzQyUyRnAlM0UlMEElM0NwcmUlMjBjbGFzcyUzRCUyMiUyMGxhbmd1YWdlLW5vbmUlMjIlM0UlMEElM0Njb2RlJTNFJTBBU1FMJTI2Z3QlM0IlMjBleGVjJTIwZGJtc19pam9iLnJlbW92ZSUyODQwMDIlMjklM0IlMEFQTCUyRlNRTCUyMHByb2NlZHVyZSUyMHN1Y2Nlc3NmdWxseSUyMGNvbXBsZXRlZC4lMEElM0MlMkZjb2RlJTNFJTBBJTNDJTJGcHJlJTNF[/vc_raw_html][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]
In the following use case, as sysdba I am trying to remove the job that belongs to another user - 'AMS2000' that results in error - ORA-23421.
As a sysdba, when you try removing job belonging to another user, you will get ORA-23421
SQL> BEGIN DBMS_JOB.remove(4002);
2 END;
3 /
BEGIN DBMS_JOB.remove(4002);
*
ERROR at line 1:
ORA-23421: job number 4002 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 781
ORA-06512: at "SYS.DBMS_JOB", line 180
ORA-06512: at line 1Using dbms_ijob.remove one can remove job belonging to another schema
SQL> exec dbms_ijob.remove(4002);
PL/SQL procedure successfully completed.
30 TB moved with zero downtime
