title: DBMS SCHEDULER Job with input
body: <p>Hi I have a stored procedure in oracle that I would like to run periodically. Firstly I got my DBMS_SCHEDULER Job to compile <strong>(see below)</strong> and I can even see the job be created and drop it though I don't see the result of the stored procedure occur in the table it is supposed to effect and the stored procedure has been tested.</p>
  
  <pre><code>BEGIN                      
    DBMS_SCHEDULER.CREATE_JOB ( 
     job_name        =&gt; 'JOB_QUERY',
     job_type        =&gt; 'PLSQL_BLOCK',       -- see oracle documentation on types --
     job_action      =&gt; 'BEGIN RUNREPORT(''NAME'', ''VERSION'', ''04-Jun-13'', ''11-Jun-13''); END;',
     start_date      =&gt; to_date('2013-08-19 16:35:00', 'YYYY-MM-DD HH24:MI:SS' ),
     repeat_interval =&gt; 'FREQ=MINUTELY;BYMINUTE=10',    -- every 10 minutes.
     end_date        =&gt; NULL, 
     enabled         =&gt; TRUE,
     comments        =&gt; 'Daily Jira Query Update');
  END;
  </code></pre>
  
  <p>I was attempting to simply make it run every ten minutes though I see no changes. Also I wanted to be able to pass SYSDATE or the current date to the procedure in the dbms_scheduler job but I cant get it to work with the apostrophes. </p>
  
  <p>Thanks</p>