Oracle DBMS_ISCHED_AGENT
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
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 12cR2
What's New In 18cR3

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