Oracle DBMS_Scheduler
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"