Oracle | DBMS_ISCHED

Oracle DBMS_ISCHED_AGENT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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 23ai 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.