select client_name, status
from dba_autotask_client;
dba jb history
select distinct client_name, window_name, job_status, job_info
from dba_autotask_job_history
where job_status <> 'SUCCEEDED'
order by 1,2;
CLIENT_NAME WINDOW_NAME JOB_STATUS JOB_INFO
------------------ --------------- ---------- -------------------------------------------
auto space advisor SATURDAY WINDOW FAILED ORA-6502: PL/SQL: numeric or value error...
auto space advisor SUNDAY WINDOW FAILED ORA-6502: PL/SQL: numeric or value error...
BEGIN
dbms_auto_task_admin.disable(
client_name => 'auto space advisor',
operation => NULL,
window_name => NULL);
END;
/
PL/SQL procedure successfully completed
select client_name, status
from dba_autotask_client
where client_name = 'auto space advisor';
CLIENT_NAME STATUS
------------------------------- --------
auto space advisor DISABLED
BEGIN
dbms_auto_task_admin.enable(
client_name => 'auto space advisor',
operation => NULL,
window_name => NULL);
END;
/
No comments:
Post a Comment