Job Creation

[fcirone]

Good morning,

I need to run a routine (can be stored procedure) once a month.
I thought of doing this using Job.
But I do not know how to proceed to create a job.
Can anyone give me another suggestion, or some tips for creating?

Thanks,
Fabio Cirone

[dr_gori]

There goes a small example:

Select all

 
VARIABLE jobno NUMBER 
BEGIN 
  DBMS_JOB.SUBMIT ( 
      :jobno, 
      'BEGIN sua_procedure; END;', 
      sysdate, 
      'add_months(trunc(sysdate,''mm''),1)');   --> vai rodar sempre no dia primeiro! 
END;

You can consult your Job doing select on user_jobs.