Logical Backup Scheduling by using dbms_scheduler
i am trying to schedule an hourly based logical backup
1-i have created a batch file which contains
exp system/gateway@orcl dumpfile=expdir:try.dmp logfile=expdir:try.dmp schemas=test
this batch file is running successfully
2-i am trying to create the following job to run every hour
JOB_NAME => 'BACKUP_JOB',
JOB_TYPE => 'EXECUTABLE',
JOB_ACTION => 'c:\backup.bat',
START_DATE => trunc(SYSDATE+1/24,'HH'),
REPEAT_INTERVAL => 'FREQ=HOURLY;INTERVAL=1',
COMMENTS => 'Logical backup');
My first question is whether it supports .bat executables
If it does then can anybody help me in this regard?
thanx in advance
why dont you just try it?
why not use windows sceduler?
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
i had tried it before posting this query but failed to do so
Originally Posted by davey23uk
i need some help in this regard if u can
well what failed, what errors do you get
Click Here to Expand Forum to Full Width