Oracle DBMS_ISCHED_AGENT
Version 18.1.0.0

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Internal agent support for DBMS_SCHEDULER
AUTHID CURRENT_USER
Dependencies
DBMS_GSM_CLOUDADMIN DBMS_ISCHED DBMS_SCHEDULER
Documented No
First Available 18.1.0.0
Security Model Owned by SYS with EXECUTE granted to GSMADMIN_INTERNAL
Source {ORACLE_HOME}/rdbms/admin/prvthisagt.plb
Subprograms
 
AGENT_INSTALL_POST_STEPS (new 18.1)
  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 (new 18.1)
  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 (new 18.1)
  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
15-MAR-18 08.00.00.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 '2018-03-15 08:00:00', '3:00'), 999, 1);

Related Topics
Built-in Functions
Built-in Packages
DBMS_ISCHED
DBMS_ISCHEDFW
DBMS_SCHEDULER
DBMS_SCHED_ARGUMENT_IMPORT
DBMS_SCHED_ATTRIBUTE_EXPORT
DBMS_SCHED_FILE_WATCHER_EXPORT
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved