Oracle | DBMS_SCHED_MAIN

Oracle DBMS_SCHED_MAIN_EXPORT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Scheduler Export Main Program

AUTHID DEFINER

Dependencies

ALL_SCHEDULER_WINDOWS	DBMS_SCHED_EXPORT_CALLOUTS	SCHEDULER$_CONSTRAINTS
ALL_TABLES	DBMS_SCHED_FILE_WATCHER_EXPORT	SCHEDULER$_CREDENTIAL
DBA_SCHEDULER_FILE_WATCHERS	DBMS_SCHED_JOB_EXPORT	SCHEDULER$_GLOBAL_ATTRIBUTE
DBA_SCHEDULER_JOBS	DBMS_SCHED_PROGRAM_EXPORT	SCHEDULER$_JOB
DBA_SCHEDULER_PROGRAMS	DBMS_SCHED_SCHEDULE_EXPORT	SCHEDULER$_JOB_ARGUMENT
DBMS_ASSERT	DBMS_SCHED_WINDOW_EXPORT	SCHEDULER$_LIGHTWEIGHT_JOB
DBMS_DATAPUMP	DBMS_SCHED_WINGRP_EXPORT	SCHEDULER$_LWJOB_OBJ
DBMS_ISCHED	DBMS_STANDARD	SCHEDULER$_NOTIFICATION
DBMS_LOB	DBMS_ZHELP	SCHEDULER$_PROGRAM
DBMS_PRIV_CAPTURE	KU$_JOBDESC	SCHEDULER$_RESOURCES
DBMS_SCHEDULER	KU$_STATUS	SCHEDULER$_SCHEDULE
DBMS_SCHED_ARGUMENT_IMPORT	NOEXP$	SCHEDULER$_STEP
DBMS_SCHED_ATTRIBUTE_EXPORT	OBJ$	SCHEDULER$_WINDOW
DBMS_SCHED_CHAIN_EXPORT	PLITBLM	SCHEDULER$_WINDOW_GROUP
DBMS_SCHED_CLASS_EXPORT	SCHEDULER$_CHAIN	SCHEDULER$_WINGRP_MEMBER
DBMS_SCHED_CONSTRAINT_EXPORT	SCHEDULER$_CLASS	USER$
DBMS_SCHED_CREDENTIAL_EXPORT

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvthesh.plb
{ORACLE_HOME}/rdbms/admin/prvtesch.plb

Subprograms

EXPORT_CHAIN	EXPORT_RESOURCE	GET_OBJECT_OWNER
EXPORT_CLASS	EXPORT_RESOURCE_CONSTRAINT	I_INSTANCE_CALLOUT_IMP
EXPORT_CONSTRAINT	EXPORT_SCHEDULE	I_SCHEMA_CALLOUT
EXPORT_CREDENTIAL	EXPORT_SCHEDULER_ATTRIBUTE	I_SCHEMA_INFO_EXP
EXPORT_FILE_WATCHER	EXPORT_SYSTEM_WINDOW	I_SYSTEM_CALLOUT_IMP
EXPORT_GRANTS	EXPORT_WINDOW	NEXT_PIECE
EXPORT_JOB	EXPORT_WINGRP	TS_TO_CHAR
EXPORT_PROGRAM

EXPORT_CHAIN

Undocumented dbms_sched_main_export.export_chain(objid IN NUMBER);

TBD

EXPORT_CLASS

Undocumented dbms_sched_main_export.export_class(objid IN NUMBER);

TBD

EXPORT_CONSTRAINT

Undocumented dbms_sched_main_export.export_constraint(objid IN NUMBER);

TBD

EXPORT_CREDENTIAL

Undocumented dbms_sched_main_export.export_credential( objid IN NUMBER, version IN NUMBER);

TBD

EXPORT_FILE_WATCHER

Undocumented dbms_sched_main_export.export_file_watcher(objid IN NUMBER);

TBD

EXPORT_GRANTS

Undocumented dbms_sched_main_export.export_grants(objid IN NUMBER);

TBD

EXPORT_JOB

Undocumented dbms_sched_main_export.export_job( objid IN NUMBER, version IN NUMBER);

TBD

EXPORT_PROGRAM

Undocumented dbms_sched_main_export.export_program( objid IN NUMBER, version IN NUMBER);

TBD

EXPORT_RESOURCE

Undocumented dbms_sched_main_export.export_resource(objid IN NUMBER);

TBD

EXPORT_RESOURCE_CONSTRAINT

Undocumented dbms_sched_main_export.export_resource_constraint(objid IN NUMBER);

TBD

EXPORT_SCHEDULE

Undocumented dbms_sched_main_export.export_schedule(objid IN NUMBER);

TBD

EXPORT_SCHEDULER_ATTRIBUTE

Undocumented dbms_sched_main_export.export_scheduler_attribute( objid IN NUMBER, version IN NUMBER);

TBD

EXPORT_SYSTEM_WINDOW

Undocumented dbms_sched_main_export.export_system_window( win_name IN VARCHAR2, res_plan IN VARCHAR2, duration IN VARCHAR2, schedule IN VARCHAR2, schedule_name IN VARCHAR2, schedule_owner IN VARCHAR2, start_date IN VARCHAR2, end_date IN VARCHAR2, priority IN VARCHAR2, comments IN VARCHAR2, inline_sched IN BINARY_INTEGER, enabled IN BINARY_INTEGER);

TBD

EXPORT_WINDOW

Undocumented dbms_sched_main_export.export_window(objid IN NUMBER);

SELECT o.obj#, o.name WIN_NAME

      FROM obj$ o, scheduler$_window sw

      WHERE o.obj# = sw.obj#;

      

       OBJ#   WIN_NAME

      ----- -----------------

      19737 MONDAY_WINDOW

      19738 TUESDAY_WINDOW

      19739 WEDNESDAY_WINDOW

      19740 THURSDAY_WINDOW

      19741 FRIDAY_WINDOW

      19742 SATURDAY_WINDOW

      19743 SUNDAY_WINDOW

      19761 WEEKNIGHT_WINDOW

      19762 WEEKEND_WINDOW

      

      exec dbms_sched_main_export.export_window(19743);

      

      PL/SQL procedure successfully completed.

EXPORT_WINGRP

Undocumented dbms_sched_main_export.export_wingrp(objid IN NUMBER);

SELECT o.obj#, o.name WIN_GRP

      FROM obj$ o, scheduler$_window_group swg

      WHERE o.obj# = swg.obj#

      AND bitand(swg.flags, 8+16) = 0;

      

       OBJ# WIN_GRP

      ----- --------------------------

      19744 MAINTENANCE_WINDOW_GROUP

      19748 ORA$AT_WGRP_OS

      19752 ORA$AT_WGRP_SA

      19756 ORA$AT_WGRP_SQ

      

      exec dbms_sched_main_export.export_wingrp(19744);

      

      PL/SQL procedure successfully completed.

GET_OBJECT_OWNER

Returns the schema owner of the identified object dbms_sched_main_export.get_object_owner(obj_id IN NUMBER) RETURN VARCHAR2;

SELECT dbms_sched_main_export.get_object_owner(42)

      FROM dual;

      

      DBMS_SCHED_MAIN_EXPORT.GET_OBJECT_OWNER(42)

      --------------------------------------------

      SYS

I_INSTANCE_CALLOUT_IMP

Undocumented dbms_sched_main_export.i_instance_callout_imp( obj_name IN VARCHAR2, obj_schema IN VARCHAR2, obj_type IN NUMBER, prepost IN BINARY_INTEGER, alt_name OUT VARCHAR2);

TBD

I_SCHEMA_CALLOUT

Undocumented dbms_sched_main_export.i_schema_callout( schema IN VARCHAR2, prepost IN BINARY_INTEGER, version IN NUMBER);

TBD

I_SCHEMA_INFO_EXP

Undocumented dbms_sched_main_export.i_schema_info_exp( schema IN VARCHAR2, prepost IN BINARY_INTEGER, version IN NUMBER);

TBD

I_SYSTEM_CALLOUT_IMP

Undocumented dbms_sched_main_export.i_system_callout_imp(prepost IN BINARY_INTEGER);

TBD

NEXT_PIECE

Undocumented dbms_sched_main_export.next_piece(more_left IN OUT BOOLEAN) RETURN VARCHAR2;

TBD

TS_TO_CHAR

Returns a syntactically valid, fully formatted, TO_TIMESTAMP_TZ statement dbms_sched_main_export.ts_to_char(ts IN TIMESTAMP WITH TIME ZONE) RETURN VARCHAR2;

CREATE TABLE tint_test (

      msg        VARCHAR2(25),

      start_date TIMESTAMP WITH TIME ZONE,

      end_date   TIMESTAMP WITH TIME ZONE,

      duration_1  INTERVAL DAY(5) TO SECOND,

      duration_2  INTERVAL YEAR TO MONTH);

      

      INSERT INTO tint_test

      (msg, start_date, end_date)

      VALUES

      ('my plane ride',

      timestamp'2021-11-08 17:02:32.212 US/Eastern',

      timestamp'2021-11-08 19:10:12.235 US/Pacific');

      

      COMMIT;

      

      SELECT start_date

      FROM tint_test;

      

      START_DATE

      ---------------------------------------

      08-NOV-21 05.02.32.212000 PM US/EASTERN

      

      SELECT dbms_sched_main_export.ts_to_char(start_date)

      FROM tint_test;

      

      DBMS_SCHED_MAIN_EXPORT.TS_TO_CHAR(START_DATE)

      ------------------------------------------------------------------------------------------

      TO_TIMESTAMP_TZ('08-NOV-2021 05.02.32.212000000 PM US/EASTERN','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english')