How to associate a credential to a job of type "CHAIN"
Hi,
I'm trying to define one job of type CHAIN which contains steps that run a number of programs of type STORED_PROCEDURE and a program of type EXECUTABLE (which has to be run if some programs run with success).
Since the executable is a Windows command file, I need to associate a credential to the job.
I created the credential and tried to assign it to the job, but I get the following error:
ORA-27351: conflicting values of job attributes CREDENTIAL_NAME and JOB_TYPE
Please note that I'm not associating a destination, because I want the job to run on local database. According to the "Oracle Database Administrator's Guide 11g Release 2", "A job with a NULL destination_name attribute runs on the host where the job is created".