oracle - DBMS SCHEDULER Job with input -


hi have stored procedure in oracle run periodically. firstly got dbms_scheduler job compile (see below) , can see job created , drop though don't see result of stored procedure occur in table supposed effect , stored procedure has been tested.

begin                         dbms_scheduler.create_job (     job_name        => 'job_query',    job_type        => 'plsql_block',       -- see oracle documentation on types --    job_action      => 'begin runreport(''name'', ''version'', ''04-jun-13'', ''11-jun-13''); end;',    start_date      => to_date('2013-08-19 16:35:00', 'yyyy-mm-dd hh24:mi:ss' ),    repeat_interval => 'freq=minutely;byminute=10',    -- every 10 minutes.    end_date        => null,     enabled         => true,    comments        => 'daily jira query update'); end; 

i attempting make run every ten minutes though see no changes. wanted able pass sysdate or current date procedure in dbms_scheduler job cant work apostrophes.

thanks

you have commit dml statements. there no commit in pl/sql block , guess in procedure runreport either.

you don't need apostrophe around sysdate, it's not string literal.

job_action      => 'begin runreport(''name'', ''version'', sysdate, ''11-jun-13''); commit; end;', 

byminute not mean expect. documentation: "this specifies minute on job run. valid values 0 59. example, 45 means 45 minutes past chosen hour". need

repeat_interval => 'freq=minutely;interval=10' 

you can check next run date , more querying user_scheduler_jobs.


Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -