why the view dba_scheduler_running_jobs when queried by a session logon trigger but the job that ses
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 )
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 )
0