Saturday, October 29, 2011

Oracle Database Scheduler


BEGIN
    sys.DBMS_SCHEDULER.CREATE_SCHEDULE (
     
        repeat_interval  => 'FREQ=MINUTELY;INTERVAL=2',    
        start_date => TO_TIMESTAMP_TZ('2011-10-29 15:57:26 Asia/Riyadh','YYYY-MM-DD HH24.MI.SS TZR'),
        schedule_name  => '"EVERY2minut"');
       
END;

No comments:

Post a Comment