BEGIN
dbms_scheduler.create_job(
job_name => 'del_archive',
job_type => 'EXECUTABLE',
job_action => 'd:\ld\oracle\del.bat',
start_date => '14-MAR-12 4:52.00.00 PM ASIA/CALCUTTA',
repeat_interval => 'freq=DAILY',
enabled => TRUE,
comments => 'delete old archivelogs');
END;
/
exec DBMS_SCHEDULER.run_job ('del_archive');
BEGIN
DBMS_SCHEDULER.drop_JOB (job_name => 'del_archive');
END;
/
No comments:
Post a Comment