Create Simple Job - Oracle

[GabrielDB]

Good Morning!

I am a beginner in Oracle, I have the need to create a simple job to perform procedures
IDE -> Oracle SQL Developer

99] Thanks for the help

[dr_gori]

See if this topic helps:
http://en.glufke.net/oracle/viewtopic.php?f=6&t=8126 http://en.glufke.net/oracle/viewtopic.php?f=16&t=8885

[Rafael de oliveira]

Good afternoon, I created a job that will run a procedure.

I want it to run every 30 minutes.

Select all

 
begin 
  sys.dbms_job.change(job => 66, 
                      what => 'LOG_RES_PROD_FECHADO_RESUMO;', 
                      next_date => to_date('27-03-2014 14:00:00', 'dd-mm-yyyy hh24:mi:ss'), 
                      interval => 'SYSDATE + 1/48'); 
  commit; 
end; 

He currently performs as follows, begins at 14:00:00, the next he plays for 14:30:06, then 15:00:13 and so by against.
He changes half in half an hour, but he is adding the runtime to the next run.
I would like no way, to execute whenever at certain times 14:00:00, 14:30:00 and so on.

What am I doing wrong in the creation of Job and what should I do to correct?

Thanks for everyone's attention.