Database Administration (MOSC)

MOSC Banner

why the view dba_scheduler_running_jobs when queried by a session logon trigger but the job that ses

edited Dec 20, 2010 7:59AM in Database Administration (MOSC) 1 commentAnswered
When performing the below test, the job that session is running does not show up from the select?
DROP USER FINTST CASCADE;

CREATE USER FINTST
  IDENTIFIED BY x;
  -- 1 Role for FINTST
  GRANT DBA TO FINTST;
  GRANT UNLIMITED TABLESPACE TO FINTST;
  GRANT SELECT ON SYS.DBA_SCHEDULER_RUNNING_JOBS TO FINTST;

connect fintst/x

drop sequence  seq_vdot_job_example;
drop table     tbl_vdot_job_example;

create sequence seq_vdot_job_example;

create table tbl_vdot_job_example
     ( seq           number(4),
       called_by     varchar2(10),
       running_jobs  number(38,0),
       time_stamp    timestamp(6) );

create or replace procedure prc_vdot_job_example( p_caller IN tbl_vdot_job_example.called_by%TYPE )

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center