RE:Programar copia de seguridad
Creo que esto va por bun camino, lo he encontrado en una web
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;