A simple example of calling a scheduled task in Oracle

1. Create a test table

Create Table g_test

(
ID number (12 ),
C_date date

);

2. Create a stored procedure

Create or replace procedure prc_g_test is
Begin
Insert into g_test values (seq_cam_action_id.nextval, sysdate );
End prc_g_test;

3. Create a scheduled task

PLSQL defines job:

Declare
Job number;
Begin
SYS. dbms_job.submit (job, 'prc _ g_test; ', sysdate, 'sysdate + 100 ');
End;

Command Line definition job:

Variable job1 number;

Begin

SYS. dbms_job.submit (job =>: job1,
What => 'prc _ g_test ;',
Next_date => to_date ('22-10-2008 10:06:41 ', 'dd-mm-yyyy hh24: MI: ss '),
Interval => 'sysdate + 100'); -- 1/1440 minutes a day, that is, once a minute to run the test process
Commit;

End;
/