Scheduling Oracle export jobs
For complete details on scheduling Oracle jobs, se Dr. Tim Hall's
scheduling Oracle import and export jobs.
For scheduling DBA maintenance scripts, see the scripts in the
bestselling book "Oracle
Tuning: The Definitive Reference":
In this article,
show how to avoid embedding the Oracle “system” password in a
scheduled export job by skipping a shell script and cron, and using
the dbms_scheduler utility instead.
Below we see that the export is scheduled with
a call to the create_job procedure:
job_class_name => 'backup',
resource_consumer_group => 'DEFAULT_CONSUMER_GROUP',
comments => 'Backup, Export etc');
job_name => 'full_export',
job_type => 'STORED_PROCEDURE',
job_action => 'SP_FULLEXPORT.EXP',
start_date => '30-MAR-06 07.00.00 PM Europe/Zurich',
repeat_interval => 'FREQ=DAILY;BYHOUR=19',
end_date => '30-MAR-22 07.00.00 PM Europe/Zurich',
job_class => 'backup',
comments => 'Full Export');
Scheduling Oracle exports with the internal scheduler also has the
benefit or re-starting if the database is down during the scheduled
export time, and a Cron will not re-schedule a missed job.
Get the Complete
Oracle Utility Information
The landmark book
Utilities The Definitive Reference" contains over 600 pages of
filled with valuable information on Oracle's secret utilities.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.