1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| BEGIN
dbms_scheduler.create_job(
job_name => '"SYSTEM"."LANCEMENT_SAUVEGARDE_RMAN"',
job_type => 'EXECUTABLE',
job_action => '/backup/scripts/backup_rman.sh',
repeat_interval => 'FREQ=DAILY;BYHOUR=5;BYMINUTE=0;BYSECOND=0',
start_date => to_timestamp_tz('2019-01-21 21:30', 'YYYY-MM-DD HH24:MI'),
job_class => '"DEFAULT_JOB_CLASS"',
comments => 'Sauvegarde rman de la base',
auto_drop => FALSE,
number_of_arguments => 3,
enabled => FALSE
);
dbms_scheduler.set_job_argument_value(
job_name => '"SYSTEM"."LANCEMENT_SAUVEGARDE"',
argument_position => 1,
argument_value => '-d=BDNAME'
);
dbms_scheduler.set_job_argument_value(
job_name => '"SYSTEM"."LANCEMENT_SAUVEGARDE"',
argument_position => 2,
argument_value => '-t=level_0'
);
dbms_scheduler.set_job_argument_value(
job_name => '"SYSTEM"."LANCEMENT_SAUVEGARDE"',
argument_position => 3,
argument_value => '-c=CATALOGUE'
);
dbms_scheduler.enable( '"SYSTEM"."LANCEMENT_SAUVEGARDE_RMAN"' );
END;
/ |
Partager