1 Reply Latest reply: Oct 22, 2012 1:38 AM by spajdy RSS

    ORA-27475: "JOB" must be a job

    user11942774
      Hi All,
      When ever i am calling the below from a procedure i am getting the error,ORA-27475: "DBREPORT.GATEKEEPER_JOB" must be a job.
      I am getting this error in first drop box it self in(DBMS_SCHEDULER.DROP_JOB ).
      Please help.
                                   DBMS_SCHEDULER.DROP_JOB 
                                  (
                                     job_name   => 'Gatekeeper_Job',
                                     force  => TRUE,
                                     commit_semantics   => 'STOP_ON_FIRST_ERROR'
                                  );
                                                                                                  
                               DBMS_SCHEDULER.create_job (
                                job_name              => 'Gatekeeper_Job',
                                job_type              => 'EXECUTABLE',
                                job_action            => '/home/cobr_sftp/var/controllingload/download/dbcobra_transfer_gatekeeper.sh',
                                 number_of_arguments   => 4,  
                               -- auto_drop             => true,
                                 enabled               => FALSE,
                                comments              => 'CREATE_PROGRAM test using a schell script'
                                   );
                                     
                             DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (
                              job_name                => 'Gatekeeper_Job',
                              argument_position           => 1,
                              argument_value          => ip_d_filename              );
                                          
                              DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (
                              job_name                => 'Gatekeeper_Job',
                              argument_position           => 2,
                              argument_value          => v_ftype                          );                       
                                          
                              DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (
                              job_name                => 'Gatekeeper_Job',
                              argument_position           => 3,
                              argument_value          => v_d_db_name          );
                                          
                              DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (
                              job_name                => 'Gatekeeper_Job',
                              argument_position           => 4,
                              argument_value          => v_sendoraddress      );
                                          
                              DBMS_SCHEDULER.enable ('Gatekeeper_Job');
      Edited by: user11942774 on Oct 22, 2012 11:21 PM