BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
    (
       job_name        => 'TOPUP.sj_businessgather_cardpaystat'
      ,start_date      => TO_TIMESTAMP_TZ('2012/08/22 04:30:00.000000 +08:00','yyyy/mm/dd hh24:mi:ss.ff tzr')
      ,repeat_interval => 'FREQ=DAILY;BYHOUR=04;BYMINUTE=30;BYSECOND=0;INTERVAL=1'
      ,end_date        => NULL
      ,job_class       => 'DEFAULT_JOB_CLASS'
      ,job_type        => 'STORED_PROCEDURE'
      ,job_action      => 'TOPUP.SP_BUSINESSGATHER_CARDPAYSTAT'
      ,comments        => '营业额数据采集(手机/充值卡/网银)&充值卡每日使用统计'
    );
END;
/

exec dbms_scheduler.enable('sj_businessgather_cardpaystat');

BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
    (
       job_name        => 'TOPUP.sj_finance_report_audit'
      ,start_date      => TO_TIMESTAMP_TZ('2012/08/22 03:30:00.000000 +08:00','yyyy/mm/dd hh24:mi:ss.ff tzr')
      ,repeat_interval => 'FREQ=DAILY;BYHOUR=03;BYMINUTE=30;BYSECOND=0;INTERVAL=1'
      ,end_date        => NULL
      ,job_class       => 'DEFAULT_JOB_CLASS'
      ,job_type        => 'STORED_PROCEDURE'
      ,job_action      => 'TOPUP.SP_FINANCE_REPORT_AUDIT'
      ,comments        => '商户(代理商/代充商)各明细财务报表(含加款/余额/结算/盈亏统计)'
    );
END;
/

exec dbms_scheduler.enable('sj_finance_report_audit');

ITPub博客

oracle_schedjob 示例

最新文章