Oracle | DBMS_ISCHED_REMDB

Oracle DBMS_ISCHED_REMDB_JOB Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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.

TRACE_ENTRY

Start Tracing dbms_isched_remdb_job.trace_entry(routine_name IN VARCHAR2);

TBD

TRACE_EXIT

End Tracing dbms_isched_remdb_job.trace_exit( routine_name IN VARCHAR2); ecode IN BINARY_INTEGER);

TBD

WRITE_TRACE

Undocumented dbms_isched_remdb_job.write_trace( trc_str IN VARCHAR2, add_tst IN BOOLEAN);

TBD