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 will be available on generic Linux platforms in January and soon on AIX and Windows

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