Job Scheduler for EXPDP Dump

CREATE DIRECTORY DPUMP_DIR1 AS 'f:\expdp1213';

GRANT read, write ON DIRECTORY EXPORT_AUTO TO ldbo;

begin

dbms_scheduler.create_job

(job_name => 'expdp',

job_type => 'EXECUTABLE',

job_action => 'expdp ldbo/ldbo@ksh1112srv full=Y directory=EXPORT_AUTO dumpfile=ksh1112.DMP LOGFILE=ksh1112.LOG',

start_date => '01-APR-12 09:00.00.00 PM ASIA/CALCUTTA',

repeat_interval => 'freq=DAILY',

enabled => TRUE,

comments=>'expdp');

end;

/

exec dbms_scheduler.run_job ('expdp');