8 Replies Latest reply on Jun 2, 2014 3:12 PM by GregV

    Received an error "ORA-27351 conflicting values of job attributes DESTINATION_NAME and JOB_TYPE"


      I have a bunch of DBMS_SCHEDULER jobs running on our production DB. The same set of jobs were replicated on the TEST database. I tried to set up destination_name in each jobs to run the jobs on production DB only. The above error was received when I create the job.



          job_name          => 'XYZ'

         ,job-type            => 'PLSQL_BLOCK'

         ,job_action        => 'BEGIN null; END;

         ,start_date        => SYSDATE

         ,repeat_interval  => 'FREQ=DAILY;BYHOUR=4;BYMINUTE=30;BYSECOND=0'

         ,enabled            => FALSE

         ,credential_name => 'SYSORA'

         ,destination_name => null

         ,comments           => 'Scheduled job XYZ.');




      I would appreciate any suggestions.