Database Administration (MOSC)

MOSC Banner

Oracle DBMS_Scheduler

edited Oct 24, 2011 1:36AM in Database Administration (MOSC) 2 commentsAnswered
Dear DBMS_SCHEDULER Administrators,

Is there a restriction on executing a chained job on a remote host ?

I can successfully execute a local job with JOB_TYPE=>CHAIN and a number of chained programs of PROGRAM_TYPE=>EXECUTABLE.

I can successfully execute a remote job of JOB_TYPE=>EXECUTABLE and a CREDENTIAL_NAME attribute on the remote host.

However after adding the CREDENTIAL_NAME attribute to the chained job the following error occurs.

"java.sql.SQLException: ORA-27351: conflicting values of job attributes CREDENTIAL_NAME and JOB_TYPE
ORA-06512: at "SYS.DBMS_ISCHED", line 185 ORA-06512: at "SYS.DBMS_SCHEDULER", line 486 ORA-06512: at line 2"

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