Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
221 vnguyen 1 
 
2 
BEGIN
3 
dbms_scheduler.disable1_calendar_check();
4 
dbms_scheduler.create_schedule('"HOUSEKEEP_RUN_LEVEL_SCHEDULE"','28-JUN-07 01.00.00.000000 AM +08:00',
5 
'FREQ=DAILY; BYHOUR=1',
6 
NULL,
7 
'Run at 1am all days'
8 
);
9 
COMMIT;
10 
END;
11 
/
12 
 
13 
 
14 
BEGIN
15 
dbms_scheduler.create_job('"DAILY_HOUSEKEEPING_SCHEDULE"',
16 
job_type=>'STORED_PROCEDURE', job_action=>
17 
'pk_buildapi.delete_out_of_date_schedule'
18 
, number_of_arguments=>0,
19 
schedule_name=>'"HOUSEKEEP_RUN_LEVEL_SCHEDULE"',
20 
job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>FALSE,comments=>
21 
'Clean Table when the scheduled resume datetime is past the current datetime'
22 
);
23 
dbms_scheduler.enable('"DAILY_HOUSEKEEPING_SCHEDULE"');
24 
COMMIT;
25 
END;
26 
/
27