Oracle | DBMS_ISCHED

Oracle DBMS_ISCHED_AGENT Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Internal agent support for DBMS_SCHEDULER

AUTHID CURRENT_USER

Dependencies

DBMS_GSM_CLOUDADMIN

DBMS_ISCHED

DBMS_SCHEDULER

Documented No

First Available 18c

Security Model Owned by SYS with EXECUTE granted to GSMADMIN_INTERNAL

Source {ORACLE_HOME}/rdbms/admin/prvthisagt.plb

Subprograms

AGENT_INSTALL_POST_STEPS	GET_AGENT_REGISTRATION_INFO	SET_AGENT_REGISTRATION_INFO
AGENT_INSTALL_PRE_STEPS

AGENT_INSTALL_POST_STEPS

Undocumented dbms_isched_agent.agent_install_post_steps;

exec dbms_isched_agent.agent_install_pre_steps;

      

      PL/SQL procedure successfully completed.

AGENT_INSTALL_PRE_STEPS

Undocumented dbms_isched_agent.agent_install_pre_steps;

exec dbms_isched_agent.agent_install_post_steps;

      

      PL/SQL procedure successfully completed.

GET_AGENT_REGISTRATION_INFO

Undocumented dbms_isched_agent.get_agent_registration_info( hash OUT VARCHAR2, expiration_date OUT TIMESTAMP WITH TIME ZONE, max_uses OUT BINARY_INTEGER, fail_count OUT BINARY_INTEGER);

set serveroutput on

      

      DECLARE

       hval VARCHAR2(60);

       edval TIMESTAMP WITH TIME ZONE;

       muval PLS_INTEGER;

       fcval PLS_INTEGER;

      BEGIN

        dbms_isched_agent.get_agent_registration_info(hval, edval, muval, fcval);

        dbms_output.put_line(hval);

        dbms_output.put_line(edval);

        dbms_output.put_line(muval);

        dbms_output.put_line(fcval);

      END;

      /

      

      -- in 21c returned

      
      3A1AC9C81292FC1CF0B8A4015F04C0A3D21BAE2D

      25-MAR-20 20.23.06.000000 AM +03:00

      999

      1

      -- in 23c returns no values

SET_AGENT_REGISTRATION_INFO

Undocumented dbms_isched_agent.set_agent_registration_info( hash IN VARCHAR2, expiration_date IN TIMESTAMP WITH TIME ZONE, max_users IN PLS_INTEGER, fail_count IN PLS_INTEGER);

exec dbms_isched_agent.set_agent_registration_info('3A1AC9C81292FC1CF0B8A4015F04C0A3D21BAE2D', 
      TO_TIMESTAMP_TZ('2023-10-12 11:00:00 -8:00', 'YYYY-MM-DD HH:MI:SS TZH:TZM'), 999, 1);

      PL/SQL procedure successfully completed.