Kreirao sam job:
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'my_job1',
job_type => 'PLSQL_BLOCK',
job_action => 'delete xx_tabela;',
repeat_interval => 'freq=DAILY; byhour=15; byminute=15; bysecond=0;',
comments => 'delete xx_tabela');
END;
/
Mana je sto nece da se okine :)
Gde sam pogresio ?