I want to execute a query on a periodic basis.Believe have to use DBMS SCHEDULER OPTION.

have created the procedure.

PROCEDURE do_job IS
BEGIN
INSERT INTO job_table
(now)
VALUES
(SYSDATE);
COMMIT;
END;

Create anothe proc which wud execute the previous proc on a periodic basis.

PROCEDURE job_call AS
JobNo user_jobs.job%TYPE;
BEGIN
dbms_job.submit(JobNo, 'begin do_job; end;', SYSDATE,
'SYSDATE + 1/24/60');
COMMIT;
END;

AM USING ORACLE
PL HELP
THANKS!