Create a JOB to run a certain procedure once a day for example, run the following script in SQLPLUS.
jobno variable number;
instno variable number;
begin
dbms_job.submit (: jobno,
‘BEGIN Nome_da_Procedure; END; ‘
, trunc (sysdate) +3/24,
‘SYSDATE + 1,
TRUE
);
END;
/
To check the scheduled jobs.
SELECT * FROM dba_jobs;
To check if it is running.
select * from dba_jobs_running;
To delete jobs.
DELETE FROM WHERE dba_jobs job = 99;
To check when was the last execution.
select JOB, LAST_DATE, LAST_SEC, NEXT_DATE, NEXT_SEC, INTERVAL, FAILURES from dba_jobs;