Oracle | DBMS_ISCHED

Oracle DBMS_ISCHED_AGENT Version 21c

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

dbms_isched_agent.agent_install_post_steps;

SQL> exec dbms_isched_agent.agent_install_pre_steps;

      

      PL/SQL procedure successfully completed.

AGENT_INSTALL_PRE_STEPS

dbms_isched_agent.agent_install_pre_steps;

SQL> exec dbms_isched_agent.agent_install_post_steps;

      BEGIN dbms_isched_agent.agent_install_post_steps; 
      END;

      *

      ERROR at line 1:

      ORA-01031: insufficient privileges

      ORA-06512: at "SYS.DBMS_ISCHED", line 9812

      ORA-06512: at "SYS.DBMS_ISCHED_AGENT", line 56

      ORA-06512: at line 1

GET_AGENT_REGISTRATION_INFO

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);

SQL> DECLARE

        2   hval VARCHAR2(60);

        3   edval TIMESTAMP WITH TIME ZONE;

        4   muval PLS_INTEGER;

        5   fcval PLS_INTEGER;

        6  BEGIN

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

        8    dbms_output.put_line(hval);

        9    dbms_output.put_line(edval);

       10    dbms_output.put_line(muval);

       11    dbms_output.put_line(fcval);

       12* END;

      SQL> /

      3A1AC9C81292FC1CF0B8A4015F04C0A3D21BAE2D

      25-MAR-20 20.23.06.000000 AM +03:00

      999

      1

SET_AGENT_REGISTRATION_INFO

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', FROM_TZ(TIMESTAMP '2020-09-25 
      20:25:47', '3:00'), 999, 1);