This discussion is archived
1 Reply Latest reply: Oct 21, 2012 11:38 PM by spajdy RSS

ORA-27475: "JOB" must be a job

user11942774 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points