Recent content by Wask8N

  1. W

    Convert repeat_interval from DBMS scheduler to a usable datatype

    Might as well answer my own question since this post has 50 views or so. Found out through a peer there is a function in oracle that converts repeat_intervals to dates. CREATE OR REPLACE FUNCTION SUPPORT_SERVICES.CMN_DBMS_REPEAT_INTERVAL_TO_DT ( p_repeat_interval_str IN VARCHAR2 := NULL...
  2. W

    Convert repeat_interval from DBMS scheduler to a usable datatype

    Making a custom job scheduler that pulls job from our oracle DB and I would like to be able to convert a repeat_interval format into something I can use to test against job start times so the app knows when to run the next job. So far the logic I have pulls the next_start_time field and adds...
Top