set serveroutput on
DECLARE
PROCEDURE display(p_param IN VARCHAR2) AS
l_result VARCHAR2(50);
BEGIN
DBMS_SCHEDULER.get_scheduler_attribute(
attribute => p_param,
value => l_result);
DBMS_OUTPUT.put_line(RPAD(p_param, 30, ' ') || ' : ' || l_result);
END;
BEGIN
display('current_open_window');
display('default_timezone');
display('email_sender');
display('email_server');
display('event_expiry_time');
display('log_history');
display('max_job_slave_processes');
display('scheduler_disabled');
END;
Procédure PL/SQL terminée.
current_open_window : SATURDAY_WINDOW
default_timezone : PST8PDT
email_sender :
email_server :
event_expiry_time :
log_history : 30
max_job_slave_processes :
scheduler_disabled :
Procédure PL/SQL terminée.