SYS.DBMS_SCHEDULER
BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB (
job_name => '"SYSTEM"."MULT2"',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN
INSERT INTO HR.HEXA VALUES(''IND'',''KER'');
INSERT INTO HR.HEXA VALUES(''NETHERLAND'',''HOLLAND'');
COMMIT;
END;',
number_of_arguments => 0,
start_date => SYSTIMESTAMP,
repeat_interval => 'FREQ=MINUTELY',
end_date => NULL,
job_class => '"SYS"."DEFAULT_JOB_CLASS"',
enabled => FALSE,
auto_drop => FALSE,
comments => 'MULT2 Descri');
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE(
name => '"SYSTEM"."MULT2"',
attribute => 'logging_level', value => DBMS_SCHEDULER.LOGGING_OFF);
SYS.DBMS_SCHEDULER.enable(
name => '"SYSTEM"."MULT2"');
END;
/
No comments:
Post a Comment