dbms_scheduler.create_job (job_name => 'DBMS_JOB$_'||ln_job_no
,job_type => 'PLSQL_BLOCK'
,job_action => 'begin bpg_post_batch.bpc_gen_post_batch('
||p_batch_no
||','||ln_job_no
||','||''''||p_user||''''
||','||''''||p_prog||''''
||','||'to_date('||''''||to_char(p_date,'dd/mm/rrrr')||''''||','||''''||'dd/mm/rrrr'||''''||')'
||','||'to_date('||''''||to_char(p_batch_date,'dd/mm/rrrr')||''''||','||''''||'dd/mm/rrrr'||''''||')'
||'); end;'
,start_date => systimestamp
,auto_drop => true
,enabled => true
);
DBMS\_SCHEDULER.SET\_ATTRIBUTE ( name => 'DBMS\_JOB$\_'||ln\_job\_no
,attribute => 'ALLOW\_RUNS\_IN\_RESTRICTED\_MODE'
,value => TRUE
);
DBMS\_SCHEDULER.ENABLE('DBMS\_JOB$\_'||ln\_job\_no);
DBMS\_SCHEDULER.run\_job('DBMS\_JOB$\_'||ln\_job\_no);
I try to run job under restricted mode where my userid has below system privileges but job is not running. It only run after i disable to restricted mode.
GRANT ANALYZE ANY TO ABCDIS;
GRANT CREATE SESSION TO ABCDIS;
GRANT QUERY REWRITE TO ABCDIS;
GRANT RESTRICTED SESSION TO ABCDIS;
Can advise how to run the job where DB is under restricted mode? thank you