| dbms_scheduler problem [message #208293] |
Sat, 09 December 2006 02:51  |
baju
Messages: 12
Registered: December 2006
|
Junior Member |
|
|
i want to take backup of the db using export and with dbms_scheduler that will automatically run the sh file.
here is my script:
BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name=>'OFFICE.EXPORT',
job_type => 'EXECUTABLE',
job_action =>'$ORACLE_BASE/exp.sh',
start_date=>'09-DEC-06 01.00.00 PM',
repeat_interval=>'TRUNC(SYSDATE+1)+23/24',
enabled => TRUE,
comments => 'export 118');
END;
/
and here is my exp.sh file:
exp office/xxxxx@xxxxx FILE="$ORACLE_BASE/exp/export.DMP" LOG="$ORACLE_BASE/exp/exp_export.log" OWNER=BDOFFICE DIRECT=Y FEEDBACK=10000 CONSISTENT=Y
but it is not working.
it gives the following error.
>SELECT JOB_NAME, STATUS, ERROR# FROM
DBA_SCHEDULER_JOB_RUN_DETAILS;
EXPORT FAILED 27369
can u plz help me?
what is the problem?
thanks in advance.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: dbms_scheduler problem [message #208372 is a reply to message #208368] |
Sat, 09 December 2006 23:42  |
baju
Messages: 12
Registered: December 2006
|
Junior Member |
|
|
sorry, the problem is not yet solved.
i can run the .sh file from shell. it's working.
but with the scheduler it gives the same error(error# 27369).
thanks
|
|
|
|
| Re: dbms_scheduler problem [message #208373 is a reply to message #208372] |
Sat, 09 December 2006 23:44 |
baju
Messages: 12
Registered: December 2006
|
Junior Member |
|
|
here is my scheduler script:
BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name=>'BDOFFICE.EXPORTA',
job_type => 'EXECUTABLE',
job_action =>'/u01/app/oracle/exp.sh',
start_date=>'10-DEC-06 05.00.00 AM',
repeat_interval => 'FREQ=DAILY',
enabled => TRUE,
comments => 'export daily');
END;
/
plz help me.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
