CREATE TABLE SCOTT.JR (ID NUMBER(6), DAT VARCHAR2(30),TIME DATE)

/
CREATE SEQUENCE SCOTT.JR_S

/

INSERT INTO SCOTT.JR VALUES(scott.JR_S.NEXTVAL,'FIRST TEST',SYSDATE)

/
COMMIT
/

SELECT * FROM JR
/
BEGIN
sys.dbms_scheduler.create_job(
job_name => '"SYS"."TEST_JOB"',
job_type => 'PLSQL_BLOCK',
job_action => 'begin
   INSERT INTO SCOTT.JR VALUES(scott.JR_S.NEXTVAL,''FIRST TEST'',SYSDATE);
end;',
repeat_interval => 'FREQ=SECONDLY;INTERVAL=10',
start_date => systimestamp at time zone '+9:00',
job_class => 'DEFAULT_JOB_CLASS',
auto_drop => FALSE,
enabled => TRUE);
END;
/