Re: Help getting an EXECUTABLE to run under DBMS_SCHEDULER

From: GeoPappas <PappasG_at_gmail.com>
Date: 21 Dec 2005 11:55:46 -0800
Message-ID: <1135194946.251380.272300@g44g2000cwa.googlegroups.com>

There's always at least one wise guy in the group! This group seems to have quite a few...

The real intent of the previous post was to show that the docs were incorrect.

OK, boys and girls, let's try it with a true parameter then, shall we:

BEGIN

DBMS_SCHEDULER.CREATE_JOB(
	job_name	=> 'test',
	job_type	=> 'EXECUTABLE',
	job_action	=> '/usr/bin/more /tmp/date.log',
	enabled		=> TRUE

);
END;
/

That command fails with "ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory"

So (as stated before) the docs are incorrect. Imagine that! Received on Wed Dec 21 2005 - 13:55:46 CST