Log de um JOB – Oracle 9i

[vieriParticipante]

experimenta essa consulta para verificar os Job’s.

set lin 350
col interval for a30
col what for a60
select JOB, to_char(LAST_DATE , ‘hh24:mi:ss dd/mm/yyyy’)
as UltimaExec , to_char(NEXT_DATE ,’hh24:mi:ss dd/mm/yyyy’) as Prox_Exec
, INTERVAL , what
from dba_jobs;

Agora para ver erros de pl-sql, tente a trigger abaixo.

================

Auditar errors na instância

create table
log (
dt date,
usr varchar2(30),
stmt varchar2(4000)
);

Table created.

create or replace trigger catch_error
after servererror on database
declare
l_text ora_name_list_t;
l_n number;
l_stmt varchar2(4000);
begin
l_n := ora_sql_txt( l_text );
for i in 1 .. nvl(l_text.count,0)
loop
l_stmt := l_text(i);
end loop;
l_stmt := l_stmt || ‘=> ‘;
for i in 1 .. ora_server_error_depth
loop
l_stmt := l_stmt || ora_server_error_msg(i);
end loop;
insert into log values ( sysdate, user, l_stmt );
end;
/