heartbeat table and job
shamSep 24 2008 — edited Oct 7 2008i will create a heartbeat table.
i try to use the note what is suggest on metalink note.418755.1.
i have to creat a table i do it like this
create table HEARTBEAT
(tnsalias varchar2(200 char),
times date);
and i think i need a job for this it has to bee like this
variable jobno number;
begin
dbms_job.submit(:jobno, 'insert into heartbeat values (, sysdate);',
sysdate, 'sysdate+60/(60*60*24)');
commit;
end;
/
has some ano any sample how to implement this.