Scheduling Oracle export jobs
For complete details on scheduling Oracle jobs, se Dr. Tim Hall's
book "Oracle
Job Scheduling".
Also see
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,
Fuchs Hanspeter
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:
BEGIN
DBMS_SCHEDULER.CREATE_JOB_CLASS (
job_class_name => 'backup',
resource_consumer_group => 'DEFAULT_CONSUMER_GROUP',
comments => 'Backup, Export etc');
END;
/
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
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');
END;
/
BEGIN
DBMS_SCHEDULER.ENABLE ('full_export');
END;
/
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
"Advanced Oracle
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
buy it
for 30% off directly from the publisher.
|
|
|
|
|
|