hi there,
I am having problems assigning job_class when using DBMS_SCHEDULER.CREATE_JOB:
DBMS_SCHEDULER.CREATE_SCHEDULE(
schedule_name => 'APP_REPORTING.MV_REFRESH',
repeat_interval => 'FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN;BYHOUR=5;BYMINUTE=0',
comments => 'schedule to support first iteration of materialized views refresh'
);
DBMS_SCHEDULER.CREATE_JOB_CLASS (
job_class_name => 'APP_REPORTING_MV_REFRESH',
resource_consumer_group => 'REPORTS',
comments => 'job class to support refreshing of app_reporting materialized views'
);
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'APP_REPORTING.REFRESH_LOVS',
schedule_name => 'APP_REPORTING.MV_REFRESH',
job_type => 'PLSQL_BLOCK',
job_action => 'begin dbms_mview.refresh(list => ''APP_REPORTING.LOV1_MVW'', method => ''c'', atomic_refresh => false, out_of_place => false); end;',
job_class => 'APP_REPORTING_MV_REFRESH',
enabled => true
);
the result is:
ORA-27476: "SYS"."APP_TITAN_REPORTING_MV_REFRESH" does not exist
any insight appreciated.