DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dbms_job intervals

  1. #1
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334

    dbms_job intervals

    9.2.0.5 Linux

    dmbs_job, got an interval like this sysdate + ( 10/(24*60)) which runs every 10 minutes.

    Trying to make it so it only runs every 10 minutes between 8am and 4.30pm Monday to Friday

    Is it possible?

    Thanks

  2. #2
    Join Date
    Jul 2002
    Posts
    335
    Not through dbms_job in 9i.

    You'll either have to write a wrap around and cron it or run it through 10G Grid Control if you use it.

    You won't be able to do it exactly in OEM 9i's job system unless you write extra code.

    Bazza

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    may be you can do something like

    WHAT in dbms_job

    Code:
    begin
    if to_char(sysdate, 'D') in (1,2,3,4,5) then
      if to_number(to_char(sysdate, 'HH24MI')) between 1630 and 2000
      then
        your_pl_code;
      end if;
    end if;
    end;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width