Database Administration (MOSC)

MOSC Banner

Error in dbms_scheduler executable job

edited Jan 31, 2013 2:10AM in Database Administration (MOSC) 7 commentsAnswered ✓
Hello,

I have been working with the scheduler for a couple of days trying to get an external script to run on a linux box test bench. I can run a pl/sql procedure without any problems but when I try to run an exectuable job it fails.

Machine OS: Linux

Oracle DB version: 11.2.0.2.0

Script I am running will execute outside of the oracle environment successfully. The credential I supplied can run the file. I've even tried using root as the credential without success. So I've searched the forums, google of course, and I find that that the machine has no externaljob.ora file; however, when you are using credentials I thought this file was unnecessary--I didn't delete the file it never existed. The schema I am running the job from (it isn't the SYS schema) has rights to create jobs. The script and directories above it have been chmod 755 so they should be

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center