| Scheduler not running for users other than sys [message #406525] |
Thu, 04 June 2009 07:08  |
 |
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
|
Senior Member |
|
|
Hello All,
My problem is associated with oracle scheduler.
I am creating a job using Enterprise Manager.
In this job I am providing inline schedule and command type is EXECUTABLE.
Now if I create this job as SYS user then this job is executing successfully.
But If I create this job as any other normal user then it executes with status fail.
and following is the log output
| Quote: | ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing execution agent failed with status: 2
ORA-27301: OS failure message: The system cannot find the file specified.
ORA-27302: failure occurred at: sjsec 6a
ORA-27303: additional information: The system cannot find the file specified.
|
Can anyone help me please in solving this problem?
regards,
Delna
[Edit MC: code tags changed to quote one and single line splitted at each error]
[Updated on: Thu, 04 June 2009 07:45] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Scheduler not running for users other than sys [message #406674 is a reply to message #406625] |
Fri, 05 June 2009 05:42  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
It might be a directory privileges problem - is there a directory involved, and if so, does the non-sys user you want to run the job as ahve Read priviliges on it.
Failing that, you're going have to prvide us with some details of what the Scheduler job does.
Metalink note 579365.1 is a guide to troubleshooting ORA-27300 errors.
|
|
|
|
| Re: Scheduler not running for users other than sys [message #406715 is a reply to message #406674] |
Fri, 05 June 2009 08:35 |
|
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
|
Senior Member |
|
|
Thank you Michel sir and JRowbottom sir for your concern.
@JRowbottom
| Quote: | is there a directory involved, and if so,
|
To execute external executable file we are not required to create DIRECTORY. We have to specify full path of that executable file.
See example
and I create JOB as
...
dbms_scheduler.create_job(job_name => 'SEO_PING',
job_type => 'EXECUTABLE',
job_action => 'C:\WINDOWS\SYSTEM32\CMD.EXE /C D:\SEO_PING\PNG.BAT ' || p_url_i,
auto_drop => true,
enabled => true);
dbms_scheduler.run_job('SEO_PING');
...
| Quote: | prvide us with some details of what the Scheduler job does.
|
As per my knowledge, DBMS_SCHEDULER is package introduced in 10g and is same as DBMS_JOB in previous version, with extra functionality.
And is used to run predefined work(JOB) at particular time in background (I think, I am not required to provide this detail as you are the GURU).
More is here
regards,
Delna
[Updated on: Fri, 05 June 2009 08:45] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
