8 Replies Latest reply: Jun 2, 2014 10:12 AM by GregV RSS

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

    user3191291

      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.

       

      DBMS_SCHEDULER.CREATE_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.');

       

      DBMS_SCHEDULER.ENABLE('XYZ');

       

      I would appreciate any suggestions.

       

      cy