Oracle | DBMS_ISCHED_REMDB

Oracle DBMS_ISCHED_REMDB_JOB 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 DBMS_SCHEDULER job tracing utilities

AUTHID DEFINER

Dependencies

DBMS_ISCHED

DBMS_ISCHED_REMOTE_ACCESS

DBMS_SYSTEM

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvthsch.plb

Subprograms

IS_TRACING_ON	TRACE_EXIT	WRITE_TRACE
TRACE_ENTRY

IS_TRACING_ON

Returns TRUE if tracing is enabled, else FALSE dbms_isched_remdb_job.is_tracing_on RETURN BOOLEAN;

BEGIN

        IF dbms_isched_remdb_job.is_tracing_on THEN

          dbms_output.put_line('Tracing Is Enabled');

        ELSE

          dbms_output.put_line('Tracing Is Not Enabled');

        END IF;

      END;

      /

      Tracing Is Not Enabled

      

      PL/SQL procedure successfully completed.