创建 和 删除 oracle job

begin
  sys.dbms_scheduler.create_job(job_name            => 'REG_PWDWRONGLIMIT',
                                job_type            => 'STORED_PROCEDURE',
                                job_action          => 'PRO_PWDWRONGLIMIT_CTRL',
                                start_date          => to_date('01-01-2011 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                                repeat_interval     => 'FREQ=DAILY;BYHOUR=0;BYMINUTE=0;BYSECOND=0',
                                end_date            => to_date(null),
                                job_class           => 'DBMS_JOB$',
                                enabled             => true,
                                auto_drop           => false,
                                comments            => '');
end;
/
begin
dbms_scheduler.drop_job('REG_PWDWRONGLIMI');
end;
/
begin
  sys.dbms_scheduler.create_job(job_name            => 'CLEANJOB',
                                job_type            => 'STORED_PROCEDURE',
                                job_action          => 'PRO_DRM_DELETE',
                                start_date          => to_date('08-12-2010 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                                repeat_interval     => 'Freq= Monthly;Interval=1',
                                end_date            => to_date(null),
                                job_class           => 'DBMS_JOB$',
                                enabled             => true,
                                auto_drop           => false,
                                comments            => '');
end;
/
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值