Hi all !
I want to enable dbms_scheduler audit, especially enable and disable procedures.
Unified aditing already enabled and works with another policies.
I just ran next test :
CREATE AUDIT POLICY SCHEDULER_AUDIT_POLICY
ACTIONS
execute ON dbms_scheduler ;
Done
AUDIT POLICY scheduler_audit_policy;
Audit succeeded
SELECT * FROM audit_unified_enabled_policies p where p.POLICY_NAME = 'SCHEDULER_AUDIT_POLICY';
POLICY_NAME ENABLED_OPTION ENTITY_NAME ENTITY_TYPE SUCCESS FAILURE
-------------------------------------------------------------------------------- --------------- -------------------------------------------------------------------------------- ----------- ------- -------
SCHEDULER_AUDIT_POLICY BY USER ALL USERS USER YES YES
begin
dbms_scheduler.enable(name => 'USER1.JOB_test' );
dbms_scheduler.disable (name => 'USER1.JOB_test' );
END ;
/
PL/SQL procedure successfully completed
select count(1) as f1
from audsys.aud$unified a
where a.event_timestamp > sysdate - 1/24
and a.unified_audit_policies = 'SCHEDULER_AUDIT_POLICY';
F1
----------
0
Pls help, I have no clue where is the problem( Why dbms_scheduler.enable/disable executions haven't logged ? I tried reconnecting , and repeat call to dbms_scheduler, but still no any records.