-
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
BEGIN
DBMS_SCHEDULER.create_job (
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');
END;
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.
Oracle DBA
-
Originally Posted by davey23uk
why dont you just try it?
i had tried it before posting this query but failed to do so
i need some help in this regard if u can
-
well what failed, what errors do you get
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|