Scheduling of RMAN Backup Scripts stored in recovery catalog

[M.Shakeel Azeem]

Can anybody please provide me regarding
How can we schedule the RMAN backup scripts stored in recovery catalog by using dbms_scheduler

I have read a forum regarding this issue stated below

I had a job as below
--------------------------------------------------------------------------------
BEGIN
dbms_scheduler.create_job(job_name => 'sys.whole_db_backup',
job_type => 'executable',
job_action => 'F:\whole_db_backup.bat',
start_date => to_date('2006-08-05 00:00:00',
'yyyy-mm-dd hh24:mi:ss'),
repeat_interval => 'freq=daily;interval=7',
enabled => TRUE);

END;
--------------------------------------------------------------------------------
and my whole_db_backup.bat as below

rman target xxx/xxx@mydb catalog xxx/xxx@catadb script 'whole_db_backup' log F:\rman_backup\rman_output.log

i adopt the same procedure but i was unable to do so
can u please tell me where i did it wrong and if u have another way then please provide it to me
thanx in advance

[davey23uk]

well what happened

[M.Shakeel Azeem]

well what happened

ok the dbms_scheduler is only available in 10g
can we do the same task by using dbms_job.submit available in 9i or earlier releases
I want to schedule to run .bat file by dbms_job but i didn't find the solution yet
can u plzzz help me in this regard?

[Thomasps]

DBMS_JOB cannot run external excutable file and can schedule only database internal procedures.

[M.Shakeel Azeem]

DBMS_JOB cannot run external excutable file and can schedule only database internal procedures.

How can we do the that task?

[Thomasps]

What task?

[davey23uk]

schedule it freom the os scheduler

[TimHall]

I can only assume you don't like the answer I gave you on my forum:

http://www.oracle-base.com/forums/vi...p?t=7130#11224

Or perhaps you didn't read it, since you've posted the same question to many Oracle forums!

Tim...

[pando]

I will ban him if he post again duplicates and stuff

[M.Shakeel Azeem]

I will ban him if he post again duplicates and stuff

Respected Sir, I am really very sorry for ur inconvenience.
i have posted the same question on different forums to find the best solution but it is creating a some trouble then i'll avoid for the next time
Sorry Again Sir