BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'schema.JOB'
,start_date => TO_TIMESTAMP_TZ('2017/06/07 15:00:00.000000 +07:00','yyyy/mm/dd hh24:mi:ss.ff tzr')
,repeat_interval => 'FREQ=MINUTELY;INTERVAL=10'
,end_date => NULL
,job_class => 'DEFAULT_JOB_CLASS'
,job_type => 'STORED_PROCEDURE'
,job_action => 'shema.proc_name'
,comments => 'ITSM xxxx'
);
END;
/
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'schema.JOB'
,start_date => TO_TIMESTAMP_TZ('2017/06/07 15:00:00.000000 +07:00','yyyy/mm/dd hh24:mi:ss.ff tzr')
,repeat_interval => 'FREQ=MINUTELY;INTERVAL=10'
,end_date => NULL
,job_class => 'DEFAULT_JOB_CLASS'
,job_type => 'STORED_PROCEDURE'
,job_action => 'shema.proc_name'
,comments => 'ITSM xxxx'
);
END;
/
No comments:
Post a Comment