| solution pl... 10g oracle scheduler + shell script [message #249649] |
Thu, 05 July 2007 07:52  |
annegrace1
Messages: 5
Registered: July 2007
Location: chennai
|
Junior Member |
|
|
hi..
here i wrote a code ... where it calls the ksh file and runs for everyone minute.
this shell script ll invoke a sql file and a record ll be inserted.
its getting compiled properly....
but the record is not getting inserted
help me out asap
begin
dbms_scheduler.create_job
(
job_name => 'test_shell_ann_test4',
job_type => 'EXECUTABLE',
job_action => '/home/oracle/avalon_dev/shell/create_snapshot_mv_account_deposits.ksh',
start_date => '05-JUL-2007 01:38:00 PM',
repeat_interval => 'FREQ=MINUTELY; INTERVAL=1',
enabled => true,
comments => 'Move Archived Logs to a Different Directory'
);
DBMS_SCHEDULER.ENABLE('test_shell_ann_test4');
end;
/
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: solution pl... 10g oracle scheduler + shell script [message #249806 is a reply to message #249649] |
Thu, 05 July 2007 23:44  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
So why didn't you post the error code in the 1st post?
27370, 00000, "job slave failed to launch a job of type EXECUTABLE"
// *Cause: The scheduler ran into an error when the job slave tried to start
// a job of type EXECUTABLE. The rest of the error stack will provide
// more detailed information on what the exact problem was.
// *Action: Correct the problem specified in the error stack and reschedule
// the job.
What else have you NOT shared with us?
[Updated on: Thu, 05 July 2007 23:45] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
