title: Oracle Calling a job with arguments
body: <p>I have a stored procedure parse_data which takes 3 arguments which are all NUMBER. I have created a program with three arguments and then a job that will run the stored procedure. The code looks like this:</p>
  
  <pre><code>BEGIN
    dbms_scheduler.create_program(program_name        =&gt; 'PARSE_PROGRAM',
                            program_type        =&gt; 'STORED_PROCEDURE',                                                          
                            program_action      =&gt; 'parse_data', 
                            number_of_arguments =&gt; 3,
                            enabled             =&gt; false,
                            comments            =&gt; '');
  
    dbms_scheduler.define_program_argument(program_name      =&gt; 'PARSE_PROGRAM',
                                     argument_name     =&gt; 'file_id',
                                     argument_position =&gt; 1,
                                     argument_type     =&gt; 'NUMBER',
                                     default_value     =&gt; '');
  
    dbms_scheduler.define_program_argument(program_name      =&gt; 'PARSE_PROGRAM',
                                     argument_name     =&gt; 'file_upload_id',
                                     argument_position =&gt; 2,
                                     argument_type     =&gt; 'NUMBER',
                                     default_value     =&gt; '');    
  
    dbms_scheduler.define_program_argument(program_name      =&gt; 'PARSE_PROGRAM',
                                     argument_name     =&gt; 'type_id',
                                     argument_position =&gt; 3,
                                     argument_type     =&gt; 'NUMBER',
                                     default_value     =&gt; '');                                       
  
    dbms_scheduler.enable (name =&gt; 'PARSE_PROGRAM');
  
    dbms_scheduler.create_job(job_name        =&gt; 'parse_job',
                            program_name    =&gt; 'PARSE_PROGRAM',
                            start_date      =&gt; systimestamp);
  
   END;
  </code></pre>
  
  <p>My question is now that this sql has been run and the program and job are now in the dbms, how do I actually make the call to run the job and pass in the 3 arguments?</p>