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;
/
