dbms_scheduler

#create a simple job

# plsql version

BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'job1',
job_type => 'PLSQL_BLOCK',
job_action => 'INSERT INTO employees VALUES (7935, ''SALLY'',
''DOGAN'', ''sally.dogan@xyzcorp.com'', NULL, SYSDATE,''AD_PRES'', NULL,
NULL, NULL, NULL);',
start_date => SYSDATE,
repeat_interval => 'FREQ = DAILY; INTERVAL =',
enabled => true);
END;
/

BEGIN
DBMS_SCHEDULER.DROP_JOB('job1');
END;
/


# procedure version.
create or replace procedure job_1
as
begin
DELETE FROM SYS.AUD$
WHERE NTIMESTAMP# < TO_TIMESTAMP (sysdate - 10 ); commit; end del_aud_tab; / BEGIN DBMS_SCHEDULER.CREATE_JOB( job_name => 'job_1',
job_type => 'PLSQL_BLOCK',
job_action => 'begin del_aud_tab; end;',
start_date => SYSDATE,
repeat_interval => 'FREQ = DAILY; INTERVAL =1',
enabled => true);
END;
/