Donald Burleson Click here for more Oracle News Headlines

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.