| Creating Backup Job with DBMS_SCHEDULER [message #282872] |
Sat, 24 November 2007 07:31  |
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
|
Member |
|
|
Hello,
Can someone please help me out here:
I'm using Oracle10g release 1 on windowsXP
I'm trying to create a backup job with dbms_scheduler and it's not working.
This is what I did:
I created a job as follows:
BEGIN
dbms_scheduler.create_job (
job_name => 'RMAN_FULL',
job_type => 'EXCUTABLE',
job_action => 'E:\wkdir\rman_bkp',
enabled => TRUE,
start_date => '24-NOV-2007 2:10:00 PM',
repeat_interval => 'FREQ=WEEKLY',
comments => 'Full Database Backup');
END;
/
While rman_bkp is an RMAN command but it wasn't working.
Please where do I get it wrong?
Kindly put me through the EXECUTABLE or should I use PL/SQL_BLOCK and how?
Thanks.
Regards,
Cherish
|
|
|
|
|
|
|
|
| Re: Creating Backup Job with DBMS_SCHEDULER [message #282972 is a reply to message #282873] |
Sun, 25 November 2007 14:18  |
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
|
Member |
|
|
The extension of the file rman_bkp is .sql and later tries .txt but both
ain't working.
Below is the error message I got:
ERROR at line 1:
ORA-06550: line ORA-06550: line 1, column 357:
PLS-00103: Encountered the symbol ":" when expecting one of the following:
:= . ( @ % ;, column :
ORA-06512: at "SYS.DBMS_ISCHED", line 148
ORA-06512: at "SYS.DBMS_SCHEDULER", line 374
ORA-06512: at line 2
Thanks
Cherish
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
