ORA-27475: unknown job “SYS”.”MV_MVREMOTE_REFRESH”

ORA-27475: unknown job “SYS”.”MV_MVREMOTE_REFRESH”

Cause:

Make sure that the job exists in the database

kIsH@xHydra<>BEGIN
  2           dbms_scheduler.drop_job(job_name => 'MV_MVREMOTE_REFRESH');
  3          END;
  4  /
BEGIN
*
ERROR at line 1:
ORA-27475: unknown job "SYS"."MV_MVREMOTE_REFRESH"
ORA-06512: at "SYS.DBMS_ISCHED", line 278
ORA-06512: at "SYS.DBMS_SCHEDULER", line 751
ORA-06512: at line 2

Solution:

kIsH@xHydra<>SELECT owner,job_name,program_name,job_type,job_action FROM dba_scheduler_jobs WHERE job_name LIKE '%MVREMOTE%';

OWNER                JOB_NAME             PROGRAM_NAME         JOB_TYPE             JOB_ACTION
-------------------- -------------------- -------------------- -------------------- --------------------
KISH                 MV_MVREMOTE_REFRESH                      STORED_PROCEDURE     REFRESH_MVREMOTE

kIsH@xHydra<>conn kish/password
Connected.
kIsH@xHydra<>BEGIN
  2  dbms_scheduler.drop_job(job_name => 'MV_MVREMOTE_REFRESH');
  3  END;
  4  /

PL/SQL procedure successfully completed.