This content has been marked as final. Show 7 replies
for example the same for Incremental all you have is change repeat_interva
exec DBMS_SCHEDULER.create_job ( - job_name => '<JOB_NAME>', - job_type => 'EXECUTABLE', - job_action =>'PATH\<>backup.bat ', start_date => TRUNC(SYSDATE), repeat_interval => ' ‘freq=weekly; byday=mon,wed; byhour=0; byminute=0; bysecond=0;’', end_date => NULL, enabled => TRUE, comments => 'Backup script on Wednesday, Saturday 4AM.');
Thanks for your answer but I want to do it from enterprise manager. Request you to give detailed explanation of steps from 10g /11g enterprise manager.
Thanks for more articles. But, I wanted to confirm that 2 backup jobs would be required? One for full backup and I give 72 hours interval and one jobs for incremental with 24 hours interval? Also, I wanted to know if I can change my settings so that I also get a mail when a reply to my question is received.
Please revert, I am very thankful to you for the prompt replies.
You create two create two job one for Full backup other for incremental .
Your Control Panel -> Your Watches -> Convert Check to yes .