Код моего джоба по очистке лишнего...
Цитата: DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'begin delete from supermag.sseventlog where EVENTMESSAGE like ''Запуск задачи №%'' or EVENTMESSAGE like ''Успешное завершение задачи №%'' or EVENTMESSAGE=''GarbageCollector[T]:Start. ''; delete from supermag.sseventlog where recid<(select max(recid)-20000 from supermag.sseventlog); delete from supermag.smpostinlog where recid<(select max(recid)-150000 from supermag.smpostinlog); delete from supermag.smpostoutlog where recid<(select max(recid)-150000 from supermag.smpostoutlog); commit; end; '
,next_date => to_date('16.01.2008 20:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE+1)+ 20/24'
,no_parse => TRUE
);
END;
/
commit;