Re: Access to DBMS_JOB Interval Parser?

From: Karsten Schmidt <groups_at_karsten-schmidt.com>
Date: 29 Jul 2003 03:46:30 -0700
Message-ID: <c6711ac4.0307290246.793e2f50@posting.google.com>

in sqlplus:
select <interval-string> from dual;
works fine for me..

Karsten

jerry_usenet_at_worldwideweave.com (Jerry Russell) wrote in message news:<a2cf3ef9.0307281632.67f97d76_at_posting.google.com>...
> If I wanted to parse a job interval string without actually submitting
> a job - is there any way to do this? I looked into the dbms_job
> interface in rdbms/admin, but didn't find anything useful there. I
> basically would like to have something I can pass the Oracle format
> interval string to and get back a date of the next actual run time the
> same way Oracle does to populate its dba_jobs tables.
>
> Thanks,
> Jerry
Received on Tue Jul 29 2003 - 05:46:30 CDT