no stdout and stderr log for my local external job
776645Aug 31 2010 — edited Sep 1 2010Hi,
Greeting.
I have a question for my local external job.
#1. i manually run the job(dbms_scheduler.run_job), and i want to check which time is output by /bin/date. So ii go to $ORACLE_HOME/schedule/log, no stdout and stderr log files are there.
begin
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'test',
job_type => 'EXECUTABLE',
job_action => '/bin/date',
number_of_arguments => 0,
enabled => true,
auto_drop => false
);
end;
#2. The above job without credentail run successfully. But if i set a credential that user and password is of the database local machine, i got the following error
*
ERROR at line 1:
ORA-27369: job of type EXECUTABLE failed with exit code: Input/output error
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 2
Could someone help me? Any wrong actions?