Thursday, March 15, 2012

Schedule Job for Exe file

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

Followers